Switch X & Y axis' when both data columns are dates (target/actual

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Petez2 - 31 Jan 2008 01:56 GMT

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

Reply to this Message

Jon Peltier - 31 Jan 2008 04:25 GMT

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
_______

>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
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message