Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y-axe Multiscale charting
Hi all, I have to plot 4 series in an excel chat but the values between
series are too diferent to see it well. Does anybody know how to plot it in a chart in some kind of multiscale Y-axe? My values are serie 1: 36-37-36-30-12-11 serie 2: 100345-134583-123908-290874-234986-13456 serie 3: 105-562-148-489-98-255 serie 4: 1.5-3.4-2.3-5.6-4.3-2.5 I only see well serie 2 Thanks in advance |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y-axe Multiscale charting
Hi,
Looks like you need to move the series 2 data to the secondary y axis. Double click the series and choose Secondary axis on the Axis tab. Cheers Andy Javier wrote: Hi all, I have to plot 4 series in an excel chat but the values between series are too diferent to see it well. Does anybody know how to plot it in a chart in some kind of multiscale Y-axe? My values are serie 1: 36-37-36-30-12-11 serie 2: 100345-134583-123908-290874-234986-13456 serie 3: 105-562-148-489-98-255 serie 4: 1.5-3.4-2.3-5.6-4.3-2.5 I only see well serie 2 Thanks in advance -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y-axe Multiscale charting
Javier wrote on Tue, 29 Nov 2005 07:30:04 -0800:
J Does anybody know how to plot it in a chart in some kind of J multiscale Y-axe? J My values are J serie 1: 36-37-36-30-12-11 J serie 2: 100345-134583-123908-290874-234986-13456 J serie 3: 105-562-148-489-98-255 J serie 4: 1.5-3.4-2.3-5.6-4.3-2.5 A pretty good case for a logarithmic y-axis in a real graph (scatter). I've tried you data and it works well. James Silverton. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y-axe Multiscale charting
Thanks Andy, is there only secundary y axis, nor third or fourth y axis?
"Andy Pope" wrote: Hi, Looks like you need to move the series 2 data to the secondary y axis. Double click the series and choose Secondary axis on the Axis tab. Cheers Andy Javier wrote: Hi all, I have to plot 4 series in an excel chat but the values between series are too diferent to see it well. Does anybody know how to plot it in a chart in some kind of multiscale Y-axe? My values are serie 1: 36-37-36-30-12-11 serie 2: 100345-134583-123908-290874-234986-13456 serie 3: 105-562-148-489-98-255 serie 4: 1.5-3.4-2.3-5.6-4.3-2.5 I only see well serie 2 Thanks in advance -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y-axe Multiscale charting
Hi,
If you don't mind a little construction work Jon Peltier explains how to add additional y axis. http://peltiertech.com/Excel/Charts/TertiaryAxis.html Cheers Andy Javier wrote: Thanks Andy, is there only secundary y axis, nor third or fourth y axis? "Andy Pope" wrote: Hi, Looks like you need to move the series 2 data to the secondary y axis. Double click the series and choose Secondary axis on the Axis tab. Cheers Andy Javier wrote: Hi all, I have to plot 4 series in an excel chat but the values between series are too diferent to see it well. Does anybody know how to plot it in a chart in some kind of multiscale Y-axe? My values are serie 1: 36-37-36-30-12-11 serie 2: 100345-134583-123908-290874-234986-13456 serie 3: 105-562-148-489-98-255 serie 4: 1.5-3.4-2.3-5.6-4.3-2.5 I only see well serie 2 Thanks in advance -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
training for Pivot Charting in Excel 2000 | Excel Discussion (Misc queries) | |||
Program line when charting variances? | Charts and Charting in Excel | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel | |||
Dynamic charting problems (events) | Charts and Charting in Excel | |||
Charting time? help please... | Charts and Charting in Excel |