Excel chart: Range of values on Y axis 1

[mercy]

I have three sets of data that I want to show on a line chart. The three data ranges are:

0 - 15
400 - 1,100
10,000 - 31,000

This scale ranges from 0 - 31,000 with large gaps in between the three series of data (i.e. no data for the range 1,100 to 10,000).

Is it possible to have a break in the Y axis, so instead of the Y axis going from 0 - 31,000 and showing the complete range on the Y axis, the range would hide the areas of redundancy.

Any help would be greatly received.

Thanks

 

[GlennUK]

If you show your 3rd series on a secondary axis it should look a lot better. Select the 3rd series, do Format Series, and in the Axes tab click the Plot on Secondary Axis option button.


Glenn.

 

[mercy]

Thanks for this reply, Glenn,

I've put the smaller scale (0-15) on a secondary axis - this works well.

However, the range on the primary Y axis still goes from 400 - 31,000 with no data shown in the range 1,100 to 10,000, leaving the line that shows the data in the range of 400 - 1,100 very close to the bottom of the graph and hard to read.

Is it possible to manipulate the Y axis scale so that intervals on the axis are not averaged out between the highest and lowest (currently in intervals of 500), rather the intervals at the bottom are less and gradually get greater.

Any thoughts...

Thanks so much

 

[GlennUK]

Try this to see if it's OK for you. Click the primary axis, and Format it, choose the Scale tab, and tick the Logarithmic Scale tickbox.

This shows the data in the range of 400 - 1,100 around midway up the graph.

Cheers, Glenn.

 

[mercy]

Thanks again Glenn,

using the Logarithmic Scale has worked, and as you pointed out, the range 400 - 1,100 is in the centre of the chart.

I'm showing my ignorance here; but by it's very nature, does the Logarithmic Scale only go up in factors of 10?

Your help has been great, and I am well pleased with previous assistance I have had through Tek-Tips on Acess related questions.

My work is as a volunteer for a charity where our resources are limited, so any help such as yours is valuable to us.

Best regards

Nik

 

[GlennUK]

My pleasure.

The Logarithmic Scale does go up in factos of 10, or any power of 10 ( e.g. 100, 1000 etc etc ).

Glad to have been such a help. Everybody on here seems to be very helpful indeed.

Cheers, Glenn.