d2907
d2907

Reputation: 902

Total and percentage for each column in a line and stacked column chart

I need to show in one single bar chart the number of elements of each column and also its percentage regarding the total.

With a Line and stacked columns chart, I reach this:

enter image description here

However, the tooltip option, on the line, shows me only one value, and I need to get both of them. I mean, not only that 32 but also the percentage corresponding to that value.

Is there a way to get this? maybe another chart?

Upvotes: 1

Views: 2157

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

OK. I understand the question now. Unfortunately, this isn't currently possible.

From Microsoft Community Support,

This is an expected behavior. The tooltips only show when you hover over a column data point in combo chart.

This has been submitted as an idea for Microsoft to address. Please vote and/or comment here:

Combo Charts: How to add tooltip on line

Upvotes: 1

Related Questions