But if you want to change them, select the graph and double-click on the bar whose color you want to alter.Ĭhoose the color from the right panel, and it'll be applied to the rest. Step 2: For column charts, the legends are usually color-coded well. To reverse the order, select the 'Switch rows/columns' checkbox you should be sorted. If you have a table like the one shown in the screenshot above, the chances are that Google Sheets will take the first column as the X-axis and the first column as the Y-axis. Step 1: Select the area of the table and click on Insert > Chart, and select Column Chart from the Chart type drop-down. Column charts come in handy when you want to plot changes over time or when you want to compare two data sets. Thankfully, creating a column chart is almost similar to line graphs. At the same time, if you want the Legends on the right side of the chart, click on Legend and choose the position. To name a chart, go to Chart & Axis titles, select horizontal axis title and enter the name. It’s best to name a chart if it’s a part of a presentation simply to make it is easier for others to understand the idea you're presenting. If you want to have the data points displayed, go to Chart Editor > Series, and check the Data labels checkbox.Ĭhoose the position, and that’s it! Your simple line graph is easy for you to see! For a visually appealing graph, the best option is to add a point size and shape.Īll you need to do is hover on the data points, and the results will be there for you to see. Now, you can choose the line color, the thickness of the line as well as the style. To add your personal touch, double-click on the line graph which will open up the Customize window. Step 3: At this point, the line graph is fairly basic, with no style elements. The Data range will be automatically modified.
#Line chart in google sheet vs scatter chart excel series
You can either enter it manually in the Data Range box or delete all the entries under Series except Total. To do so, all I need to do is go to the Chart editor and select Setup > Data Range option.Īs I want to plot the Total column against the Month column, the data range will be from A1 through A5 and H1 through H5. So it's up to you to choose which set of data you need and which ones to discard.įor instance, in my chart, I simply want to show the Total against each month and nothing else. Step 2: You’ll notice that the default graph will pick up every cell’s data to apply it on the graph. Click on Chart Type and select Line graph. If this is your first time plotting a chart, Sheets will pick up a default Chart type.ĭouble-click on the chart and the Chart editor will show up on the right panel.
Step 1: Select the cells containing the data that you want to plot.