Hello, When I create a graph, the primary axis always displays on the left and the secondary to the right of the chart. I have the chart created but, for clarity I need to have them switched. Primary on the right and secondary on the left. The lines and bars are where I want them, I just want to switch the two axis. It seems like it should be an easy task but.......... Any help?
Last edited by garybarrow; 11-19-2009 at 01:03 PM.
I don't know of a way to switch them, but you can create the graph with the axis you want on the left, and then add the one you want on the right.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
You need to add secondary horizontal axis.
Then you can select primary horizontal axis and set, Vertical Axis crosses at Maximum.
Select secondary horizontal axis and set Vertical Axis crosses Automatic.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks