Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Switch vertical and horizontal axis?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Switch vertical and horizontal axis?
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 _______ "Beach Lover" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Switch vertical and horizontal axis?
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" wrote: 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 _______ "Beach Lover" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Switch vertical and horizontal axis?
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 _______ "Beach Lover" wrote in message ... 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" wrote: 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 _______ "Beach Lover" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make chart with both horizontal-x axis vertical-y axis | Charts and Charting in Excel | |||
vertical vs horizontal error bars excel 2007 | Charts and Charting in Excel | |||
Add excel horizontal & vertical ruler | Excel Worksheet Functions | |||
how can i make excel from vertical to horizontal? | New Users to Excel | |||
Excel should have vertical and horizontal rulers. | Excel Discussion (Misc queries) |