If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to make break the y axis for the in the line chart
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 |
#2
|
|||
|
|||
how to make break the y axis for the in the line chart
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. -- Petr Bezucha "rupali shivapurkar" wrote: 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 . |
#3
|
|||
|
|||
how to make break the y axis for the in the line chart
Excel 2007
Y axis scale break By a proper shift... http://c0444202.cdn.cloudfiles.racks.../02_11_10.xlsx |
#4
|
|||
|
|||
how to make break the y axis for the in the line chart
Excel 2007
With primary and secondary axes. With aligned grid lines, optimized, trimmed scales. With macro. http://c0718892.cdn.cloudfiles.racks.../04_02_10.xlsm |
Thread Tools | |
Display Modes | |
|
|