• July 17, 2017
    Announcement: New site design for Microsoft Community

    In July, Microsoft will roll out the first of ongoing site improvements aimed to modernize Microsoft Community and help customers get the most out of their community experience.

    • During the roll out period, you may see the old or new site design depending on your location

    • We expect the roll out to finish by 31 July

    Note: Past private message conversations will not move to the new site design. Please save any private messages you would like to keep.

     Learn more about the upcoming site improvements in this thread.

    Thank you for being part of Microsoft Community!

 
Question
22043 views

Excel 2010 column chart with two vertical axes with bars that don't overlap

S Saulcy asked on

I'm trying to make a column chart with two vertical axes. I can get the second vertical axis to show but I can't make it so that the bars don't overlap such that they appear next to one another. I tried to use the information from one of the other questions posted, but that's not working the way I expected. Here's what my data look like:

 

Industry Avg. Weekly Wage % of State AWW
Natural Resources & Mining $1,402 173.7%
Construction $916 113.5%
Manufacturing $997 123.5%
Trade, Transport., & Utilities $700 86.7%
Information $746 92.4%
Financial Activities $848 105.1%
Prof. & Bus. Services $860 106.6%
Education & Health Svcs. $729 90.3%
Leisure & Hospitality $318 39.4%
Other Svcs. $658 81.5%
Government $849 105.2%
Total $807 100.0%

 

I want industry to appear on the horizontal axis, currency to appear on the left vertical axis, and percent to appear on the right vertical axis. Then I want the bars for the average weekly wage and the % of state average weekly wage to be next to each other rather than overlapping. Any suggestions for making this happen would be greatly appreciated.

7 people had this question

Abuse history


The answered status icon Answer
rich007a replied on

All you need to do is plot two more balnk series on your chart.

Right-click > Select data, then Add.

Add the first series:

Series Name: Blank1
Series values: ={0}

Add a second series:

Series Name: Blank2
Series values: ={0}

Move Blank2 to the secondary y axis. 

Use the up/down arrows in the Select Data dialog to set the series order to:

    Avg. Weekly Wage
    Blank1
    Blank2
    % of State AWW

You can then delete the two extra legend entries by clicking once on the legend, then once again on the Blank legend entry, then delete.

Hope that helps.

Cheers
Rich

21 people found this helpful

Abuse history


progress