5. Add a series to an existing chart

Now that you have managed to make your first line chart, you might want to make things a bit “spicier” by adding an extra line chart to the existing one (Yeah, I know… not really what you consider “spicy”). If you had previously opted for creating your graph using the “easy way”, you will discover here that it is quite simple to add data series to an existing graph. If you had used the “less easy way”, then the following steps won’t be very surprising to you. To add a new series such as “Rain (mm)”, simply right-click in the chart area or the plot area and choose Select Data.... A dialog box shows up.

Skjermbilde 2016-11-29 16.03.14Click on Add under the Legend Entries (Series) and type in the Series name as well as the Series values. Here you may either type them in (be aware that you have to use the right format for the data range…) or select it directly in the worksheet. When done, click OK to come back to the previous window. The new series should now show up in the list of Legend Entries (Series), under the series “Temperature”. Click OK to validate and admire the double line chart to you’ve just created.


Skjermbilde 2016-11-29 16.04.51You now end up with a more complex chart that contains two data series, one for temperature and one for precipitation. While the look of the chart may dramatically be improved in terms of aesthetics, there are a couple of things that can be configured differently to give the graph a better “reading”:

     – the use of bars to represent precipitation instead of a line,
     – the addition of a secondary Y-axis dedicated to the rain values
    – the Y-axis range (0 to 18) may be modified to suit better the range of data (12 to 16 for the temperatures and 0 to 2.9 for the precipitation).


We’ll see how to do that in the upcoming posts.

  Fant du det du lette etter? Did you find this helpful?
[Average: 0]