how to add a secondary axis in excel 2008 for mac

Add A Secondary Axis In Excel 2008 Series You Want
Add A Secondary Axis In Excel 2008 How To Add A

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.

Those two sets of data have two Y axes with two different scales -- the number of leads and the conversion rate -- making your chart look really wonky.

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.

Add A Secondary Axis In Excel 2008 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.

Keep in mind the options shown in each screenshot might be in different locations depending on the version of Excel youre using.

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.

Add A Secondary Axis In Excel 2008 Series You Want

Click this dropdown and select Series Percent of Nike Shoes Sold (or whichever series you want as your 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.

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.

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.

Next to Percent of Nike Shoes Sold at the bottom, click on the dropdown, and select an option below Line.

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.

How To Add A Secondary Axis In Excel 2008 For Mac