I want to display a graph vertically

[Pontus]

Hello, I have a problem with displaying a graph in excel. It seems like
the default way of displaying a graph is from left to right, that is,
the longer part stretches out to the right. On my graph, dates are on
the left (vertically) and an other factor is on the right
(horisontally). I want the dates tp be horisontally and the other
factor vertically, and the curve/graph should go from top to bottom,
like a waterfall if that better explains it. That is, I would like to
rotate the graph, but not by saving the graph as a gif-file and rotate
it in Visio for instance, but as a real excel-graph, connected to real
values.

Any ideas?


Bets regards
Harald

 

[Jon Peltier]

Harald -

If it's a horizontal bar-type chart, that's easy. Just choose that type
when creating the chart. You'll have to stretch it to make it taller.

You can't make a Line chart go vertically like that, but you can use the
values for the X range and the dates for the Y range, and create an XY
Scatter chart. You can't format the Y axis scale the same way you could
a time-scale X axis, but you can get pretty close.

- Jon