axis breaks

[ed]

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]

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

 

[ed]

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]

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