Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple colors on area chart | Charts and Charting in Excel | |||
Making a chart that uses a secondary Y axis | Charts and Charting in Excel | |||
Date gaps in chart after pivotTable | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel |