ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart Scale (https://www.excelbanter.com/charts-charting-excel/139174-chart-scale.html)

chelo

Chart Scale
 
Is it possible if I have 2 charts in one, both with different scales (1st one
-50 to 200 and the 2nd one 1000 to 1500) to take out from the y-axis part of
the scale, say for example, take out from 210 to 900, so overall i have a
clearer chart, with a scale -50 to 200 and then 1000 to 1500????

Thanks for the help.

John

Chart Scale
 
have a look here http://peltiertech.com/Excel/Charts/axes.html. these might
help
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"chelo" wrote:

Is it possible if I have 2 charts in one, both with different scales (1st one
-50 to 200 and the 2nd one 1000 to 1500) to take out from the y-axis part of
the scale, say for example, take out from 210 to 900, so overall i have a
clearer chart, with a scale -50 to 200 and then 1000 to 1500????

Thanks for the help.


chelo

Chart Scale
 
I had a look, but did not find exactly what I need. Do you know how to do it??
Thanks for your help



"John" wrote:

have a look here http://peltiertech.com/Excel/Charts/axes.html. these might
help
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"chelo" wrote:

Is it possible if I have 2 charts in one, both with different scales (1st one
-50 to 200 and the 2nd one 1000 to 1500) to take out from the y-axis part of
the scale, say for example, take out from 210 to 900, so overall i have a
clearer chart, with a scale -50 to 200 and then 1000 to 1500????

Thanks for the help.



All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com