Excel Line Graph Problem

S
Sukumaran Subaramaniyan 👤 Member for 21 years 3 months

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.

A
Alex Costaras 👤 Member for 21 years

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

A
Alex Costaras 👤 Member for 21 years

What I’m 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?

A
Alex Costaras 👤 Member for 21 years

Sorry for being dense, but what do I change it to, as the Y data is automatically calculated from the data range.

S
Sukumaran Subaramaniyan 👤 Member for 21 years 3 months

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!!!

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts