Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.charting




how to make break the y axis for the in the line chart
Hello ,
I have data like this molarity H8 H7 H3 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 H8, H7, H3. in this H7 and H3 has almost same range and H8 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




Answer: how to make break the y axis for the in the line chart
Hi Rupali,
To break the yaxis in a line chart, you can follow these steps:
Now you should have a line chart with a broken yaxis that shows all the data points for all three atoms. You can customize the chart further by adding titles, labels, and legends as needed.
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.charting




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 H8 H7 H3 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 H8, H7, H3. in this H7 and H3 has almost same range and H8 has different range. how to break the y axis for this differnt range and plot the line plot for all these together. Regards, Rupali . 
#4
Posted to microsoft.public.excel.charting




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 
#5
Posted to microsoft.public.excel.charting




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 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How do I make a chart with 4 bars on one axis/1 line on 2nd axis?  Charts and Charting in Excel  
How do I make a break in the yaxis?  Charts and Charting in Excel  
Line break in Xaxis column label?  Charts and Charting in Excel  
Combined bar and line chart (two Y axis) how to make excel know which data goes where  Charts and Charting in Excel  
make line in chart start at y axis  Charts and Charting in Excel 