How to Create a Chart with Multiple Ranges of Data in Google Sheets
Step-by-step tutorials on how you can create a chart with multiple ranges of data. We'll also take you through how to flip rows and columns so chart input is easier!
If you have to analyze financial data, chances are that you will have to analyze multiple ranges of data to find the trends that exist over time. To easily visualize them, you would need to create charts that show multiple trends.
The first thing you need to know is that Google Sheets require you to adjust the data sheets such that a single range of data is in a column, like in this way:
This is quite unusual, as we often write the data in this way:
Fortunately, the following steps are easier than what a Google search might tell you! Let us now learn how to create charts with multiple columns.
Flip Columns and Rows
You may first need to format the data so Google Sheets can create a proper multi-range chart. To flip columns and rows, do the following steps:
Step 1: Look for an empty space in the spreadsheet, and select a cell in that area.
Step 2: At that selected cell, type the following:
You could either hide the original rows or delete the original rows. But, if you delete the original rows, the transposed rows will also be gone! To keep the transposed rows, you can follow our tutorial here.
Create a Chart with Multiple Ranges of Data
For this portion we will learn how to create a line chart with multiple ranges of data in google sheets.
Let us start with the same data set, but with a few adjustments to make it more readable:
Now, here are the steps:
Step 1: Format your data into rows and columns so a chart can be created
The TRANSPOSE function can be very useful here if you want to move columns and rows.
Step 2: Select the data to be included in the chart, with the headings included
Step 3: Click Insert in the file menu, then click Chart.
Voila! A line chart now appears. We still need to improve it. As you can see, a Chart Editor Tab appears on the right corner.
To change the title, you can do the following:
Step 4: Format your Newly Created Chart in the Chart Editor
Click on the text box below the Title text in the Chart Editor tab on the right. Then type the title of the chart.
The chart title is left-aligned, by default. To center it, click on the Align symbol under Title format (that would be the button with four lines and an arrow pointing downward). Then click on the Center symbol.
Your chart title is now centered!
The Chart Editor tab also contains more customizable settings to improve the chart. For instance, you can do this: