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

  • Thread starter Thread starter rupali shivapurkar
  • Start date Start date
R

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to manually switch data from x axis to y axis in line chart? 1
Showing a break in the Y axis 1
error bars when breaking the y-axis 3
how do I break the y axis in a chart 3
How do I change X-Axis values in a chart with 2 Y-Axis? 1
In a 2 Y-Axis chart, how do I assign data ranges to an axis? 1
How to make the gridlines of a chart square 3
How do I break the value (Y) axis in an Excel chart ?? 1

Back
Top