P-V chart, get the last date on the X axis?
 

In a Price-Volume chart, how do you get the last date of your data on the X
axis to show up?

P-V chart, get the last date on the X axis?
 

Here's one way:

http://www.arouet.net/archives/2004/..._the_datas.php

You have to scroll down a bit, the page's layout is a little funny.

If you don't care about the first date also showing, here's another way
which may be marginally easier:

Have your dates in descending order in the sheet.
Create your chart.
Go to Chart menu Chart Options Axes, change Category Axis to Category.
Double click the X axis, Scale tab, select Categories in Reverse Order and
if desired Value Axis Crosses at Maximum Category.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"JudyF" wrote in message
...
In a Price-Volume chart, how do you get the last date of your data on the
X
axis to show up?