Graphing Reversing the Axis

M

Mark Buonanno @ HP

I am trying to get the categories that I can get in words that appear on the
xaxis to be simply switched with the numerical values I get on the Y axis. I
know about switching row and column but this just puts the categories into a
legend. I want the categories to be like they are on the x axis but to be on
the y axis. I spoke with lots of people and this is seemingly an impossible
task. Excel only allows the categories to be on the x axis. I used to use
Cricket Graph ten years ago and that could allow you to switch the axis
whenever you chose to do so even after the graph was plotted. Anybody got an
idea how to do this. I'm working with the scatter graph and can't seem get
this to happen.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use text descriptors as Y axis units 1
Make Y-axis values correspond to x- axis value 1
Axis formatting 0
Scatter chart with categories on x-Axis 2
Trendline Not Appearing In Chart Problem ? 0
Connecting ALL Data Points; Sequential Or Not ? 1
switching the axes, categories to values and vice versa 0
MS Graph: positioning items on x-axis 7

Top