Can I make Column Chart use percent and show value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I need to make the Stacked column chart use % but show the actual value in
the count. I tried the !00% Stacked Column. But as it says, it shows the 2
values as 100% but what I want to show is one value as 100% and the other as
over 100%. Then I want to show the actual value in the column (not as a
percent).

Ie 2 values are 50 and 25. The 50 would be the 100% and inside that column
would be the value 50. The 25 would be stacked on top of the 50 and be at
150% with the value of 25 inside its column.

Is this possible and if so how?

Thanks in advanced for any help!
 
Hi,

Lay your data out like this

A1: =<Leave Empty>
B1: =My Data
A2: =50
B2: =A2/$A$2
A3: =25
B3: =A3/$A$2

Format B2:B3 as percents.

Select the range A1:B3 and create a stacked column chart plotted by Rows.
Your stacked columns should now be a 100% and 150%.
Apply Data labels to the chart using the Series option. This will display
the 50 and 25 in the columns.

Cheers
Andy
 
Hi,

Make sure the chart type is stacked columns and that the source data is
plotted by rows.

Cheers
Andy
 
Back
Top