Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple 2d charts in a 3d display | Charts and Charting in Excel | |||
Charts will not display!! | Excel Discussion (Misc queries) | |||
How do I display multiple charts on one page? | Charts and Charting in Excel | |||
display multiple charts in a workshheet | Charts and Charting in Excel | |||
Auto Display of X and Y axis values for multiple charts in WKBK | Charts and Charting in Excel |