Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis date - display beyond latest date.
Hi
I'm using Excel '97 (Yeah, I know, but it's all I can afford at the moment) I want the X axis to always display a month beyond the latest date, so that the line graph stops short of the right hand side. I can get the Y Axis of value to stay ahead of the game by a consistent amount, but the date defaults back to the latest date when Auto for Max value is ticked. Is this possible? Will I have to use VBA? Please clue me in. Thanks Dave F. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis date - display beyond latest date.
Add a series to the chart. It can consist of a single point, where the date
is calculated as the maximum in your date column plus 30, and the value is any arbitrary value (like zero). Convert this series to an XY type (Chart menu Chart Type), move the series back to the primary axis (double click the new series, Axis tab), then format the series to be invisible (no marker, no line). The axis keeps moving 30 days to the right as your main data accumulates and the XY series date increases. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Dave F." wrote in message ... Hi I'm using Excel '97 (Yeah, I know, but it's all I can afford at the moment) I want the X axis to always display a month beyond the latest date, so that the line graph stops short of the right hand side. I can get the Y Axis of value to stay ahead of the game by a consistent amount, but the date defaults back to the latest date when Auto for Max value is ticked. Is this possible? Will I have to use VBA? Please clue me in. Thanks Dave F. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
How do I display the 'Date Modified' in an Excel worksheet header | Excel Discussion (Misc queries) | |||
I want to display months and years on x axis | Charts and Charting in Excel | |||
Format to display date as Quarter | Excel Discussion (Misc queries) | |||
Axis display as category | Charts and Charting in Excel |