axis breaks

ed · Feb 28th, 2002, 03:27 AM

I know this is somewhat critizised from a mathematical view, but For presentationary reasons one might like to insert breaks to the axis. One might have data that accumulates in differented parts of a specter. AS one might want to compare graphs in the low area to each other and still show a graph that is tenfold higher in the same sheet.

i would be surprised if excel had no way of doing this.

Mudface · Feb 28th, 2002, 05:09 AM

Would a logarithmic scale (under the custom charts tab) be suitable for your data?

ed · Feb 28th, 2002, 05:27 AM

Unfortunately not. A good analog to my data is chemical reactions, where you want to show speed differences beetween differnt reactions and you want to show all the reaktion with and without a catalyst. Then you will get accumuation of different reactions at low speed and similar accumulation at high speed. Lets say the y-axis is speed and the x-axis is consentration of a reactants.

Mudface · Feb 28th, 2002, 05:33 AM

I don't if this helps (I'm not too familiar with charts) but, if you have two series with wildly different y values, you can plot an xy scatter graph and put one of the series on a secondary y axis. If this is no good, sorry, perhaps someone else can help you out

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 03:27 AM	#1
ed New Member Join Date: Feb 2002 Location: Norway Posts: 2	I know this is somewhat critizised from a mathematical view, but For presentationary reasons one might like to insert breaks to the axis. One might have data that accumulates in differented parts of a specter. AS one might want to compare graphs in the low area to each other and still show a graph that is tenfold higher in the same sheet. i would be surprised if excel had no way of doing this.

Feb 28th, 2002, 05:09 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Would a logarithmic scale (under the custom charts tab) be suitable for your data?

Feb 28th, 2002, 05:27 AM	#3
ed New Member Join Date: Feb 2002 Location: Norway Posts: 2	Unfortunately not. A good analog to my data is chemical reactions, where you want to show speed differences beetween differnt reactions and you want to show all the reaktion with and without a catalyst. Then you will get accumuation of different reactions at low speed and similar accumulation at high speed. Lets say the y-axis is speed and the x-axis is consentration of a reactants.

Feb 28th, 2002, 05:33 AM	#4
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	I don't if this helps (I'm not too familiar with charts) but, if you have two series with wildly different y values, you can plot an xy scatter graph and put one of the series on a secondary y axis. If this is no good, sorry, perhaps someone else can help you out