Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 different scales on the Y-axis
I have three different columns that I want on one chart to show that they all
follow the same trend. Is there a way to have all on a line chart but so that the smallest numbers (last column) don't disappear into the x-axis line? Basically want three lines but all in the middle of the chart showing spikes & lows. ex: client A B C c1 1000 100 1.0 c2 2400 200 2.0 c3 1500 150 1.5 c4 3000 300 3.0 -- --coastal |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 different scales on the Y-axis
You can add a tertiary axis (which I don't particularly like):
http://peltiertech.com/Excel/Charts/TertiaryAxis.html or you could make a panel chart, in which the chart has three separate panels, one for each axis scale range: http://peltiertech.com/Excel/Charts/StackedCharts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "coastal" wrote in message ... I have three different columns that I want on one chart to show that they all follow the same trend. Is there a way to have all on a line chart but so that the smallest numbers (last column) don't disappear into the x-axis line? Basically want three lines but all in the middle of the chart showing spikes & lows. ex: client A B C c1 1000 100 1.0 c2 2400 200 2.0 c3 1500 150 1.5 c4 3000 300 3.0 -- --coastal |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 different scales on the Y-axis
This is almost getting there. But my problem is that the values are such
different scales that the examples given wont help. Is there some chart or manipulation of a chart that can plot a series in the 1000s as well as a series in the 1(ones) and not have the second series get lost making it look like just a flat line along the bottom over the x-axis? Thanks! -- --coastal "Jon Peltier" wrote: You can add a tertiary axis (which I don't particularly like): http://peltiertech.com/Excel/Charts/TertiaryAxis.html or you could make a panel chart, in which the chart has three separate panels, one for each axis scale range: http://peltiertech.com/Excel/Charts/StackedCharts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "coastal" wrote in message ... I have three different columns that I want on one chart to show that they all follow the same trend. Is there a way to have all on a line chart but so that the smallest numbers (last column) don't disappear into the x-axis line? Basically want three lines but all in the middle of the chart showing spikes & lows. ex: client A B C c1 1000 100 1.0 c2 2400 200 2.0 c3 1500 150 1.5 c4 3000 300 3.0 -- --coastal |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 different scales on the Y-axis
On Wed, 4 Jul 2007 14:32:02 -0700, coastal
wrote: I have three different columns that I want on one chart to show that they all follow the same trend. Is there a way to have all on a line chart but so that the smallest numbers (last column) don't disappear into the x-axis line? Basically want three lines but all in the middle of the chart showing spikes & lows. ex: client A B C c1 1000 100 1.0 c2 2400 200 2.0 c3 1500 150 1.5 c4 3000 300 3.0 Perhaps you could use a logarithmic scale? --ron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 different scales on the Y-axis
See the stacked charts example? Adjust your values (and dummy axis data
labels) so that one series is scaled from 0 to 1, the next from 1 to 2, the next from 2 to 3. Taking your example, I would scale A from 0 to 4000, and put it into the bottom part of the chart (0-1), so the plotted value A' is related to A by: A' = A/4000 I would scale B from 0 to 400 and put it into the middle part of the chart (1-2): B' = B/400 + 1 I would scale C from 0 to 0 and put it into the top part of the chart (2-3): C' = C/4 + 2 My real Y axis would have a major spacing of 1, minimum of 0 and maximum of 3. Major Y axis gridlines would separate the chart into its three parts. My dummy axis series would have points from 0 to 3 at every 0.25, with the following labels in order: 0, 1000, 2000, 3000, 0, 100, 200, 300, 0, 1, 2, 3, 4 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "coastal" wrote in message ... This is almost getting there. But my problem is that the values are such different scales that the examples given wont help. Is there some chart or manipulation of a chart that can plot a series in the 1000s as well as a series in the 1(ones) and not have the second series get lost making it look like just a flat line along the bottom over the x-axis? Thanks! -- --coastal "Jon Peltier" wrote: You can add a tertiary axis (which I don't particularly like): http://peltiertech.com/Excel/Charts/TertiaryAxis.html or you could make a panel chart, in which the chart has three separate panels, one for each axis scale range: http://peltiertech.com/Excel/Charts/StackedCharts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "coastal" wrote in message ... I have three different columns that I want on one chart to show that they all follow the same trend. Is there a way to have all on a line chart but so that the smallest numbers (last column) don't disappear into the x-axis line? Basically want three lines but all in the middle of the chart showing spikes & lows. ex: client A B C c1 1000 100 1.0 c2 2400 200 2.0 c3 1500 150 1.5 c4 3000 300 3.0 -- --coastal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I have two sets of scales on one axis? | Charts and Charting in Excel | |||
could I have dual scales on the same axis | Charts and Charting in Excel | |||
broken scales for X axis | Charts and Charting in Excel | |||
having problems with X-axis scales | Excel Discussion (Misc queries) | |||
Two different y-axis scales? | Charts and Charting in Excel |