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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks