Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default Multiple 2d charts in a 3d display

I'm trying to get a visual representation of a database of info regarding
loan analysis using a line graph. I want the data to show line items of
widely varying values, and the lines I have come out flat in some instances
because the y-axis is calibrated for up to six figures for some values, but
single digits for others. Is there any way to create several 2d charts, then
"stack" them up on a non-contiguous z-axis?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Multiple 2d charts in a 3d display

Trying to display this on a 3D chart will only frustrate you and confuse the
viewers. Stack the charts vertically in an arrangement called a panel chart:

http://peltiertech.com/Excel/Charts/StackedCharts.html
http://peltiertech.com/Excel/ChartsH...nelChart1.html

You can adjust the scales of the panels independently, because you make your
own fake axes using extra XY chart series.

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


"Greg@food family" wrote in
message ...
I'm trying to get a visual representation of a database of info regarding
loan analysis using a line graph. I want the data to show line items of
widely varying values, and the lines I have come out flat in some
instances
because the y-axis is calibrated for up to six figures for some values,
but
single digits for others. Is there any way to create several 2d charts,
then
"stack" them up on a non-contiguous z-axis?



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
Multiple 2d charts in a 3d display Greg@food family Charts and Charting in Excel 0 May 24th 07 09:18 PM
Charts will not display!! Geoff Excel Discussion (Misc queries) 1 May 9th 07 08:58 PM
How do I display multiple charts on one page? magnoliak77 Charts and Charting in Excel 1 June 30th 06 10:10 AM
display multiple charts in a workshheet hmac Charts and Charting in Excel 0 May 23rd 06 03:29 AM
Auto Display of X and Y axis values for multiple charts in WKBK Barb Reinhardt Charts and Charting in Excel 0 January 11th 06 02:46 PM


All times are GMT +1. The time now is 07:09 AM.

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

About Us

"It's about Microsoft Excel"