Excel - Excel 2007 - Switch vertical and horizontal axis?

Asked By BeachLove on 12-Feb-08 07:24 AM
I have four columns.  "A" is for a date, "B" is a number, "C" is a number,
and "D" is a dollar amount.  When I create the chart, I want the date to be
on the left side of the chart but I can only get it to display at the bottom.
I've tried using the Transpose option, but that didn't work.  Any
suggestions?




Jon Peltier replied on 12-Feb-08 07:49 AM
What type of chart? In general, if you put the Y value columns in the
worksheet to the right of the X value columns, Excel arranges the chart the
way you want. You could bring up the chart data dialog and change what
values are used for X and Y values, but it's not as easy in 2007 as in 2003.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
BeachLove replied on 12-Feb-08 08:08 AM
It is a stacked line chart.  I have tried rearranging the columns and I can't
get it to display the way I need.  I'll keep trying, but any suggestions will
be appreciated.  Thanks!
Jon Peltier replied on 12-Feb-08 10:41 PM
What values are stacked? The numbers in B and C? With the date on the
vertical axis? Excel doesn't support a line chart with a vertical category
(i.e., date) axis. Make an XY chart, with two series. The first uses A as Y
and B as X, the second uses A as Y and either C as X or another column that
computes B+C for X to simulate a stacked chart.

Note that stacked lines are confusing; people don't readily see that one
series builds on the previous one. Stacked areas and columns are less
frequently misunderstood.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______