Chart Horizontal Axis always shows last data value

[steeful]

Hello,

How do I get the horizontal axis on a chart to always show the newest data value (usually date)? This makes it easier to determine if the chart is up to date by looking at last data value, etc.

Thanks in advance.

 

[jberwald]

To be honest I am not sure I understand your question - but if you need to determine when a chart was last updated just put the update date in the footer.

 

[steeful]

Sorry, I just want the last date to show up in the chart. If I update for April 2011, I want the furthest right label on the axis to be April 2011, not March 2011 or February 2011. Whatever the latest date is in the chart data, that's what I want to show up on the label.

 

[steeful]

anyone? I thought this would be pretty basic

 

[Akashwani]

Hi,

Check out this video....

http://www.youtube.com/user/ExcelIsFun#p/search/12/7le-m8YRP6M

You need to pay attention from about 10 minutes onwards.

Good luck

Ak