Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
make chart with both horizontal-x axis vertical-y axis CEmery Charts and Charting in Excel 1 December 19th 07 08:11 PM
vertical vs horizontal error bars excel 2007 chemheel00 Charts and Charting in Excel 1 August 7th 07 06:25 PM
Add excel horizontal & vertical ruler snbahri Excel Worksheet Functions 8 December 1st 06 08:18 PM
how can i make excel from vertical to horizontal? Mariaepa New Users to Excel 2 January 2nd 06 05:21 PM
Excel should have vertical and horizontal rulers. Mgobluefanatic1 Excel Discussion (Misc queries) 1 October 17th 05 03:50 PM


All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"