How to manually switch data from x axis to y axis in line chart?

[scs.hq1]

Hi all,

I am trying to plot a line chart (with markers displayed at each data
value) and present the series in "column" format with the following
data:

A B C D E F G H I J
Zone 1 0 80 100 100 0 100 100 100 100 100
Zone 2 25 30 26 12 40 45 22 29 46 18
Zone 3 75 70 74 88 60 55 78 71 54 82

By doing so, I get the Zone 1 - 3 presented as x axis. I would like to
make Zone 1-3 to be on y axis instead but can't seem to direct Excel
to do so despite trying different ways e.g. retyping the data as
follows:


Zone 1 Zone 2 Zone 3
A 0 25 75
B 80 30 70
.... and so on

Would appreciate if any advice please. Thanks!
Davin

 

[Jon Peltier]

A line chart can only have its categories along the horizontal axis. You
could use a dummy axis to put the labels up the vertical axis:

http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

or you could make a Dot Plot:

http://peltiertech.com/Excel/Charts/DotPlot.html

But your data is easy enough to fudge. Enter the numbers 1, 2, 3 instead of
Zone 1, Zone 2, Zone 3. Apply a custom number format of "Zone "0 and the
cells will look the same, except Excel will treat the cells as numbers
instead of text labels. That means you can plot these cells on the Y axis.

- Jon