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 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
• 63,720 points

0 votes
1 answer

## datatable remove column on export to pdf and excel

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

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

0 votes
1 answer

## Downloading Tableau data into Excel (scientific notation column)

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

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

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

0 votes
1 answer

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

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

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

0 votes
1 answer

## IF - ELSE IF - ELSE Structure in Excel

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

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

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