I have a spreadsheet that I input data in and get averages out.
This is updated weekly and the averages continue across the spreadsheet.
I have a line chart in place that is supposed to plot the averages.
I have set the spreadsheet up in advance so I enter just the figures for the week and the functions do the rest.
I have noticed that the chart plots all the data fine except the last average.
The source data for the chart covers the area the averages fall in, but just doesn't show the final piece of data.
eg. If I have an average of 78 then 45 across the sheet it plots the 78 but not 45.
Why is this??
Additional although not a major issue, the chart covers an area that is blank until it is filled. The chart obviously plots this as 0.
Can I change this to show the last average across the chart while still leaving the worksheet area blank??
This is updated weekly and the averages continue across the spreadsheet.
I have a line chart in place that is supposed to plot the averages.
I have set the spreadsheet up in advance so I enter just the figures for the week and the functions do the rest.
I have noticed that the chart plots all the data fine except the last average.
The source data for the chart covers the area the averages fall in, but just doesn't show the final piece of data.
eg. If I have an average of 78 then 45 across the sheet it plots the 78 but not 45.
Why is this??
Additional although not a major issue, the chart covers an area that is blank until it is filled. The chart obviously plots this as 0.
Can I change this to show the last average across the chart while still leaving the worksheet area blank??