Axis Break In Excel How To Add A
Axis Break In Excel Series You Want

Under the Customize tab, scroll down to the bottom where it says Series Number of Shoes Sold.

HubSpot uses the information you provide to us to contact you about our relevant content, products, and services.

Update to the latest version for a better, faster, stronger (and safer) browsing experience.

You need something called a secondary axis: it allows you to use the same X axis with two different sets of Y-axis data with two different scales.

Axis Break In Excel How To Add A

To help you solve this pesky graphing problem, well show you how to add a secondary axis in Excel on a Mac, PC, or in a Google Doc spreadsheet.

Then, click Charts, navigate to the Column section, and select Clustered Column -- the first option, as shown below.

This should pop up in dark green next to Chart Design, as shown to the far right in the screenshot below.

Axis Break In Excel Series You Want

Click this dropdown and select Series Percent of Nike Shoes Sold (or whichever series you want as your secondary axis).

A pop-up will come out that gives you the option to select a secondary axis.

If youre using a version of Excel that doesnt provide you with this formatting button, move on to the fourth step below.

To give this data a secondary Y axis, click on one of these bars just above the X axis line until they become highlighted.

See how you have Percent of Nike Shoes Sold overlapping with the Number of Shoes Sold columns Ideally, you want to present your secondary data series in a different form than your columns.

Then, click into Chart Design on the menu bar on top of your Excel spreadsheet.

Select the first line graph option that appears, as shown below.

Next, click on the Insert tab, two buttons to the right of File.

Click on the small vertical bar chart icon at the top left of this section.

After your chart appears, you will see that two new tabs appear at the end of your dashboard: Design, and Format.

Select Series Percent of Nike Shoes Sold -- or whichever you want your secondary axis to be.

To give this data a secondary Y axis, double-click on one of these bars just above the X axis line until they become highlighted.

Then click on Insert on your menu, and click Chart -- its located toward the bottom of the drop-down.

If that doesnt appear in the preview immediately, click on More next to the Recommended charts header, and you will be able to select it there.

If the chart still doesnt look right, you can also check the option to Switch rows columns.

Axis Break In Excel For Mac