I am working on a lab write up and I was wondering how I can insert a break
into a graph to demonstrate that the values are not the same distance apart.

Hi,

Have a look at these techniques for adding a break to the y axis.

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://www.andypope.info/charts/brokencolumn.htm
http://tushar-mehta.com/excel/newsgr...ial/index.html

Cheers
Andy

runnergirl00 wrote:
I am working on a lab write up and I was wondering how I can insert a break
into a graph to demonstrate that the values are not the same distance apart.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thank you so much! Your post was very helpful in solving my problem!

"Andy Pope" wrote:

Hi,

Have a look at these techniques for adding a break to the y axis.

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://www.andypope.info/charts/brokencolumn.htm
http://tushar-mehta.com/excel/newsgr...ial/index.html

Cheers
Andy

runnergirl00 wrote:
I am working on a lab write up and I was wondering how I can insert a break
into a graph to demonstrate that the values are not the same distance apart.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

To insert a break into a graph in Microsoft Excel:

1. Select the data range that you want to create a chart for.
2. Go to the Insert tab in the ribbon and select the type of chart you want to create. For example, you can choose a line chart or a column chart.
3. Once you have created the chart, right-click on the vertical axis (the one that shows the values) and select Format Axis from the drop-down menu.
4. In the Format Axis pane that appears on the right-hand side of the screen, scroll down to the Axis Options section and look for the Breaks option.
5. Check the box next to Axis Breaks to enable this feature.
6. You can then choose the type of break you want to insert, such as a wavy line or a straight line.
7. Adjust the settings for the break, such as the size and position, until it looks the way you want it to.
8. Click Close to apply the changes to the chart.