Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make the Y axis in an excel chart the category axis?
I would like to create a scatter chart where the x axis is the value axis and
the y axis is the category axis, and I can't seem to figure out how to switch the two. |
#2
|
|||
|
|||
Jon's site will tell you how to do so . . .
http://www.peltiertech.com/Excel/Cha....html#SwitchXY ---- Regards, John Mansfield http://www.pdbook.com "megnadoodle" wrote: I would like to create a scatter chart where the x axis is the value axis and the y axis is the category axis, and I can't seem to figure out how to switch the two. |
#3
|
|||
|
|||
Hi,
If you want the Y axis to be a category axis then try this example. http://www.peltiertech.com/Excel/Cha...ml#VertCatAxis Cheers Andy megnadoodle wrote: I would like to create a scatter chart where the x axis is the value axis and the y axis is the category axis, and I can't seem to figure out how to switch the two. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
why can I not format a secondary axis in excel x? | Charts and Charting in Excel | |||
How do I break the value (Y) axis in an Excel chart ?? | Charts and Charting in Excel | |||
How can I print an excel chart so a picture is not distorted? | Charts and Charting in Excel | |||
Excel chart like the FTSE chart | Charts and Charting in Excel |