Jump to content

Excel Line Chart

Hi,

I've got the below line chart

image.png.b013dc369de537cfa203636a7d771657.png

How do I bring the 4 line series closer together, so there is a huge gap between them

 

Thank you

Link to comment
Share on other sites

Link to post
Share on other sites

You change scale for y axis (%) from adapted to fixed, maybe 0-100%. Right now 1 & 3 have values around 2% while 2 & 4 have values around 18%. You are using adapted scale which has only values up to 20%. Change that to 0-100% with 20% or 10% jumps and you have values almost next to each other.

^^^^ That's my post ^^^^
<-- This is me --- That's your scrollbar -->
vvvv Who's there? vvvv

Link to comment
Share on other sites

Link to post
Share on other sites

On 6/5/2018 at 2:42 AM, spbr said:

How do I bring the 4 line series closer together, so there is a huge gap between them

Two options that I can think of would be to either switch the Y-Axis to a Logarithmic Scaling or to plot Series 1&3 with the Y-Axis on the Left showing the values for 0 to 10% and Series 2&4 with the Y-Axis on the right showing the values for 10 to 20%.  Either way, when presenting the data, you should make a clear note of how you are modifying the graph.

Link to comment
Share on other sites

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×