Excel Line Chart

[spbr]

Hi,

I've got the below line chart

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

 

Thank you

[LogicalDrm]

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.

[WMGroomAK]

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.