I have existing charts in a spreadsheet using staggered data that are fine, but when I update the chart after adding new data it is changing from 4 single lines to 1 single long line and no matter how many times I change the information in the 'Select data' icon it keeps putting into a single line. Does anyone know why? or what I can do to get over this problem?
An example of my existing chart is attached. The chart on the left is how I want it to look and how it looked previously. The chart on the right is what I am now getting from the same data table.
The table of data is below. I want to use the figures in column I (but only the positive values - greater than zero). When I did the first charts I went into the 'Select chart data' icon, in the chart data range I selected the sets of data in column I that I wanted (for 2011/2012 I need all 5 rows in column I for that year, for 2012/2013 I want the first 4 rows in column I for that year, for 2013/2014 I want the first 3 rows in column I for that year etc etc). I used the control button to select each set of data. I then went into the 'Legend Entries (Series) area and selected the cells containing the financial year names individually, and then into the Horizontal Category to select cells B28:B32 to give the values year1, year2, etc.
This worked on numerous charts but when I update any of the figures now it is changing to a single line as in the graph on the right and I cannot seem to get it to change.
Bookmarks