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. |
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. |
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 |
All times are GMT +1. The time now is 09:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com