Share via

Bar Chart - count & percentage

Anonymous
2012-02-08T14:32:16+00:00

I want to show both the count & the percentage on my bar chart.  I have a chart that compares data between two years.  I am able to create the comparison charts with either the percentage of increase or decrease or the count but I want to show both the percentage and the count as data labels. Can I do that?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2012-02-08T16:47:51+00:00

    You can do this by adding the secondary Axis. 

    To do this in Excel 2007:

    • Click on a location within your chart so that the chart is activated and then from ribbon menu select the new contextual option Chart Tools.
    • From here select the Layout tab and and then move over to the left side of the ribbon menu and you should see a drop down that says "Chart Area" or  something else based on what you have clicked on in the chart.  Using this drop down select "Series 'xx' " with the xx denoting what you wish to make as the second axis, for instance "Series Percentage".
    • Next click on Format Selection (located directly beneth the drop down).
    • From the new po-up menu, at the bottom of the Series Options is a section called "Plot Series On".  Select "Secondary Axis", click close.
    • Finally from the Chart Tools contextual menu on the Layout tab select Axes.  From the new drop down you will be able to tell Excel how to display the secondary Axis items and you can format from the Format tab.

    You can play around with the options to see how you want it to look.

    Hope this helps.

    30+ people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-07-09T19:18:05+00:00

    I am not sure what you mean, Windows 7 does not change Excel... Are you using Office 2010? 

    If you are using Office 2010 the process is the largely the same as written in my original post.  I dont believe this will work with Pie Graphs, so keep that in mind.  Make sure you are selecting the chart, then the "Layout" from the new contextual menu that appears called "Chart Tools".

    Next you will need to navigate your mouse all the way to the left where you should see a drop down box sandwiched between "File" and "Format Selection".  Using this drop down select "Series 'xx' " with the xx denoting what you wish to make as the second axis.

    Next click on "Format Selection" (located directly beneth the drop down) and from the new pop-up menu, there is a section called "Plot Series On".  Select "Secondary Axis", click close.

    Finally from the Chart Tools contextual menu on the Layout tab select Axes.  From the new drop down you will be able to tell Excel how to display the secondary Axis items and you can format from the Format tab.

    Hope this helps.

    0 comments
  2. Anonymous
    2013-07-05T06:05:15+00:00

    Hi JESSE,

    Can you please suggest how can we do this in windows 7. I m trying but not getting through.

    thanks

    sam

    0 comments