Chart problem.

bidmet

Board Regular
Joined
Jun 25, 2004
Messages
76
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??
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,111,596
Messages
5,541,154
Members
410,543
Latest member
ExcelGlenn
Top