How to easily add a series in an Excel graph in different ways
Occasionally you may find that you set up a chart and at some later point you want to add a new series into it, so, for example, this one is pulling through the first bill, but we want to bring the second bill through.
We are going to show you three ways you can add a new series to a chart. Our preferred method is the following:- Go to the chart and either under the Chart Tools Designs, Select Data – or you can right click on it and you’ll see the options exists here saying “Select Data” and when you click on it, it will tell you where it is currently looking and what it is called. If you click “Add” , you can now specify exactly what you want to add to this graph. The Series Name, I am going to say exists here and where the Series Values – there they go. And you’ll see when I say OK the chart has already been done.
At this point as well you can click here and perhaps you want this one to appear first so at the moment Bill 1 is here, Bill 2 there, I’ll move it up and you’ll see they switch around. Let’s just undo this- it is now back to a single series.
Another way to add a series, if I click on a graph, notice that these little coloured blocks appear, showing what the graph is looking at. If I have set it up nicely so that the information is next to each other – I can actually go to this graph and get my cursor to change so you can see it has got the expansion option, click and drag and when I drag over that area and I let go, you’ll see that series is added into the graph.
The third option – let me just undo this again- is just as simple. You click and you highlight the new series – it must look the same as the old series, you copy it – either Control C or you right click and you go to copy, click on the chart, you’ll see there is an option here called Paste and when I paste, you’ll see the series is added into the chart.
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
The remarkable thing about Adrian's presentation is his ability to further change and adapt the focus of the course as issues arose. He was also able to keep the more skilled delegates challenged...– Alexander Proudfoot Consultants