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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reversing Dates Sequence along X axis in a chart 3
How to draw a graph with the X axis as a time line of date. 4
X axis titles on logarithmic scatter chart. 5
combining two line charts with different x axis intervals 2
Make Y-axis values correspond to x- axis value 1
y axis label problem 2
Primary X axis to Secondary X axis 1
Chart (scatter plot): values on X-axis. 1

Top