View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
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?