View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Switch X & Y axis' when both data columns are dates (target/actual

Chart menu Source Data Series tab: change what's in the edit boxes for X
and Y.

You could try this utility:
http://peltiertech.com/Excel/Charts/axes.html#SwitchXY

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


"Petez2" wrote in message
...
I am plotting Target vs Actual completion dates for a project management
S-Curve, using Excel. Since both data columns are "dates", Excel wants to
use
"dates" on the Value Axis (Y), while putting the Task #s on the X axis.
How
do I switch axis' so that time runs horizontally on the X axis, with the
Task
#s on the Y?

Thanks