Show Last Date in Time Series Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Buster - 26 Dec 2003 14:51 GMT

I have a time series line chart with dates on the x-axis.
The dates run in ascending order , left to right. The
last date in the series does not appear on the chart.

After numerous attempts with different scenarios using
the various functions under the "Scale" tab in
the "Formatting Axis" dialoge box, I have been unable to
display the last value in this series on the chart.

Is there a method for doing this? Thank you in advance
for taking time to responed.

Reply to this Message

Debra Dalgleish - 27 Dec 2003 14:14 GMT

Is the last value missing, or is the last date not labeled on the axis?

All the values should appear automatically, but the axis usually shows
every nth label, which you can set in the Format Axis dialog box. If the
last date is not one of the set intervals, it won't appear on the axis,
but its value will appear in the chart.

> I have a time series line chart with dates on the x-axis.
> The dates run in ascending order , left to right. The
[quoted text clipped - 7 lines]
> Is there a method for doing this? Thank you in advance
> for taking time to responed.

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message