Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Label last x-axis value

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
renderman - 10 Nov 2006 17:54 GMT
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
Andy Pope - 13 Nov 2006 09:18 GMT
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

> Hello,
>
[quoted text clipped - 8 lines]
> Thanks,
>   Chris

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.