how to make break the y axis for the in the line chart

[rupali shivapurkar]

Hello ,

I have data like this

molarity H-8 H-7 H-3
0.1 7.872 3.88 3.404
0.066666667 7.874 3.892 3.426
0.05 7.874 3.897 3.436
0.033333333 7.873 3.895 3.432
0.025 7.874 3.9 3.44

molarity on x axis and all other 3 are on y axis.

i have one column for molarity and other 3 colums for 3 different
atoms H-8, H-7, H-3.

in this H-7 and H-3 has almost same range and H-8 has different
range.

how to break the y axis for this differnt range and plot the line plot
for all these together.

Regards,
Rupali

 

[PBezucha]

Rupali,
The easiest though not single solution is using primary and secondary axes
with different scales for both groups of data. Check out the Help. By a
proper shift between scales you can even signify the mutual position of both.

 

[Herbert Seidenberg]

Excel 2007
Y axis scale break
By a proper shift...
http://c0444202.cdn.cloudfiles.rackspacecloud.com/02_11_10.xlsx

 

[Herbert Seidenberg]

Excel 2007
With primary and secondary axes.
With aligned grid lines, optimized, trimmed scales.
With macro.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_02_10.xlsm