Excel 2007 - How can I switch the data on vertical and horizontal

B

Beach Lover

I'm using Excel 2007 and would like to know how to switch the way the data
shows up on the chart. I would like to have the information that is being
plotted on the vertical axis on the horizontal axis instead and visa versa.

Thanks for any help.
 
B

Beach Lover

Additional information: If I'm in the right area........I've tried
formatting the data point, but the "Series Options" Primary and Secondary
Axis options are grayed out.
 

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

Dynamically Scale Gantt Chart Time Scale 2
Assign data series to primary axis 1
Display Horizontal and Vertical Line In Area Chart (Excel 2007) 2
Overlay charts in 2007 2
Time Scales on Horizontal Axis - Excel Charts 1
Creating and Editing a Chart 1
Excel 2003 Line Chart - Switch Axis Position 2
Offset Horizontal axis data 1

Top