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

P

Petez2

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: X-axis labeling 1
X Y (Scatter) Chart EXCEL 2007 1
Chart distorts secondary axis when the x-axis is logarithmic 5
showing start of each month as tick mark & label on X-Y chart 1
Switching X and Y axis 4
x and y axis 5
Trying to change x-axis date range 5
Hide Graph of Data Outside X-Axis Range 2

Top