For a better experience, please enable JavaScript in your browser before proceeding.

Each comma after the final 0 will divide the displayed number by another thousand.

Axis Break In Excel Series Would Have

The new dummy series would have a data value as zero or blank.

This will put in a single gap the same width as the other x-axis categories in your bar chart, but for the new series.

If you are already doing that, but still having 2004,2005,2006,2007 show up on the x-axis then format the x-axis to a text axis.

In cell A2 if the value A then allow both positive and negative integers.

I have attached sample data, i need someone to help me convert the left side to how the data looks on the right.

Doing so checks the Axis Titles box and places text boxes next to the vertical axis and below the horizontal axis.

Click either of the Axis Title boxes to place your mouse cursor in it.

Select the Axis Title text, type in a new label for the axis, and then click the graph.

This will allow you to right-click onto edit mode; from here you can add words on any amount of lines you need.

A cursor will appear, and youll have the ability to enter the desired text.

However, your axis labels will reappear if you switch back to the original chart type.

Open an Excel document.

Click the graph. 3.

Click 4. Click Axis Titles 5.

Click an Axis Title text box.

Type in the label youd like the axis to have.

Axis Break In Excel For Free By Whitelisting

Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker.

If you really cant stand to see another ad again, then please consider supporting our work with a contribution to wikiHow.