Showing percentages above bars on Excel column graph

0 votes
I have a graph that obtains information from a pivot table, and as a result, I have a distribution of counts (how many in category A, how many in B, how many in C, etc)

However, I also want to display a percentage of the total above each bar. I could, for instance, explain, "This bar for Category A shows we obviously have 2000 of it, but look at the figure above the bar, it's just 15% of the total."

Is this all make sense?
Nov 16, 2022 in Others by Kithuzzz
• 38,010 points
373 views

1 answer to this question.

0 votes

Solution 

  1. Use a line series to show the %
  2. Update the data labels above the bars to link back directly to other cells
I hope this helps you.
answered Nov 17, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

datatable remove column on export to pdf and excel

When we are using jquery datatable for ...READ MORE

answered Feb 17, 2022 in Others by gaurav
• 23,260 points
3,881 views
0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10, 2022 in Others by gaurav
• 23,260 points
7,161 views
0 votes
1 answer

Downloading Tableau data into Excel (scientific notation column)

Due to Excel's internal floating point numbering ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,720 points
704 views
0 votes
1 answer

Excel VBA to change background image of shape by clicking on shape

You need to keep track of what ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,720 points
2,389 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
2,517 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,684 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,670 points
830 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
3,017 views
0 votes
1 answer

Excel - Make a graph that shows number of occurrences of each value in a column

There is probably a better way to ...READ MORE

answered Oct 21, 2022 in Others by narikkadan
• 63,720 points
8,699 views
0 votes
1 answer

Is there a way to produce a sum according to date/time stamp values of another column on excel?

Assuming the input data for the second ...READ MORE

answered Mar 25, 2023 in Others by narikkadan
• 63,720 points
453 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP