Label last x-axis value

R

renderman

Hello,

I hope that somebody can help me with the following issue with Excel
Charts.
The x-axis is the timeaxis with labels every twelve months. However,
the displayed data may extend beyond the last label. That looks very
odd.

Is there a way to force Excel to display the last x-axis value?

Thanks,
Chris
 
A

Andy Pope

Hi,

No not if the label does not fall on a major step.
You could add a dummy data series that has an x value that matches the
last period and a Y value of 0. The use the data label set to display
Category. If the chart is a line chart you series will need to include
empty data for all preceding points.

This example show you how to do it using MSGraph, but the technique is
the same in excel.
http://www.andypope.info/ngs/ng41.htm

Cheers
Andy
 
Top