Visualization in tables is the key to ease of perception. If there is a lot of data, and they are present in the form of a panel of monotonous cells, it is difficult to draw quick conclusions. How did the indicators change over the year, how critical is the backlog from the plan? These and other points are best shown with the help of diagrams and graphs. Especially if you need to provide a report to management or the customer.
In Ringostat , every department works with Google Sheets on a daily basis . So that employees do not spend 10-15 minutes to understand the data, visualization is immediately configure in our dashboards. Here we will not consider the basics, how to create a table in Google Docs, etc.
How to freeze a row in Google Sheets
In this article, we will share the tricks that were most useful to us and will be useful to everyone who works with data.
This is a simple and basic thing, but with a large amount of data, you should definitely use it. Otherwise, when rewinding the table, you can easily Taiwan Email List confuse which indicator you are looking at now.
To do this, you can fix the first or first few lines. You can also freeze a column if you have the desire indicators written vertically. Go to the tab View – Freeze and select the desire rows.
Thus, in Google Sheets, you can fix the header, which will be display when scrolling through the document.
How to design charts
We will not consider in detail how to draw Google Spreadsheets charts, because it is easy to do and is describe in the Google manual . You can follow the link to it , copy it for yourself and look at the formulas to understand how it works. In its third tab is the “database”, from which data is pull into the first sheet.
A graph or chart can be create for any range. Select the desire area with the mouse, and then go to the section Insert – Chart . A menu will open on the right side of the screen, where in the Additional – Series section you can set the color . Similarly, if you need to change the color in an already built chart.