Excel Line Graph Problem
Forum Sponsor
Top Posters
Doron El
3 posts
James Williams
74 posts
Erim INANC
2 posts
gorilpk
0 posts
Ricky
0 posts
pinoyplanner
1 posts
Siddharth Ranadive
1 posts
Aidar Kurmantayev
0 posts
Dave Morgan
0 posts
blake333_
0 posts
Alex,
At present there are not many choices and flexibility in Excel. You got to bear with Scatter XY graph with values on both X and Y axes.
Else, if you got AutoCAD using value and category try to draw the graph manually. Maybe it will help you.
Good Luck.
Hi, sorry but these still have the X axis as the category axis and the Y axis as the value axis. I need to turn them round so that the categories appear on the verical axis rather than the horizontal. Thanks anyway
hi there,

maybe u can see the sample as per attached..
is it like the one u said...i just try to guest your needs
What Im trying to do is make the Y axis a Catagory axis and the X axis the value axis (By default they are the other way round)for line graphs (not scatter graphs, which have bot X and Y as values axes). Anyone have any suggestions?
Sorry for being dense, but what do I change it to, as the Y data is automatically calculated from the data range.
Go to: Source Data > Series tab > change the range of cells at Values and Category (X) Axis Labels.
This will swap the X data to Y axes and Y data to X axes.
Cheers!!!