Switching axis in Excel 2003
April 30, 2008 9:29 AM Subscribe
I'm using Microsoft Excel 2003 at work and I need to make a chart where the category (x) axis is the y axis; is there any way of doing this?
posted by Rustbeard to computers & internet (5 answers total) 1 user marked this as a favorite
I've been trying to figure out a way to make this work this morning and can't seem to get it to work. I have tried puting the actual values in the category section and the category in the values section but it does not work out that way. Or is there even just a way i can turn the chart around?
I'm using a line chart by the way.
This is for a science paper and I need to show percent %organic matter (thats the values) through depth (category) so it would be nice to have depth on the y axis going down and then the values plotted showing how it progress further down. This makes it a lot easier to understand then what I have currently which is displayed left to right.