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??
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Forum statistics

Threads
1,141,160
Messages
5,704,649
Members
421,360
Latest member
Rhodia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top