asked on
Excel - Counts and percentages in same bar
I have the following table:
2011 2012 2013
Visitor# 10 5 5
% 50 25 25
I would like to indicate both the # and the % in the same bar graph - but am not able to.
Please advise.
Thank you.
2011 2012 2013
Visitor# 10 5 5
% 50 25 25
I would like to indicate both the # and the % in the same bar graph - but am not able to.
Please advise.
Thank you.
Microsoft Excel
Last Comment
Subodh Tiwari (Neeraj)
ASKER
Close, but I was hoping to indicate the number within the bar, and the percentages above the bar.
Thank you
Thank you
Or this.....
sample-chart.xlsx
sample-chart.xlsx
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
They are all awesome - thank you everyone for your quick responses.
ASKER
Thank you
ASKER
sktneer - please confirm how you got the % above the bars, with the % sign.
Thank you.
Thank you.
ASKER
I see your chart type is a stacked column - without fill I take it. Please confirm your methodology.
ASKER
I am able to recreate - with percentages - remove the fill from a stacked chart - did you manually enter the % sign - or am I missing a step here?
Thank you.
Thank you.
Yes it is 2D Stacked chart.
Format the % Data Series to set the fill color to No Fill and Border Color to No line.
Format the Data Labels for % Series and set the Label Position to Inside Base and set the Custom Number formatting with #,##0" %";-#,##0" %"
Hope this helps.
Format the % Data Series to set the fill color to No Fill and Border Color to No line.
Format the Data Labels for % Series and set the Label Position to Inside Base and set the Custom Number formatting with #,##0" %";-#,##0" %"
Hope this helps.
ASKER
Thank you - this did help.
You're welcome. Glad I could help.
Just select A1:D3 -> Insert -> 1st bar chart
sample.xlsx