m$ Excel Help
•
8 Oct 2008, 11:06
•
Journals
Hey people of Crossfire I need your help! No doubt it's really easy 'n incredibly simple but I be having a complete mind fuck - not used excell in eons.
I'm wanting to add % next to the value on the bar graph. So the graph shows values in the bar + % of
As in
e.g. on the right, shows 40 outta 45 on the bar - I also wanna display what percentage that is.
I canna seem to figure out how =[ 'Data Labels' has a percentage tick box in there but can't be ticked :l
Yeah I fail! Help please
I'm wanting to add % next to the value on the bar graph. So the graph shows values in the bar + % of
As in
e.g. on the right, shows 40 outta 45 on the bar - I also wanna display what percentage that is.
I canna seem to figure out how =[ 'Data Labels' has a percentage tick box in there but can't be ticked :l
Yeah I fail! Help please
If you want 0-45 to be shown with % you need to go configure cells 0-45, there is a box where you can add that it will show with % or with € etc...
Scotland has 30 cats
Holland has 40 cats
I'm after the graph to display this as a standard bar graph – but at the top of the bars, to also display the % - just as a tag.
England has 20 cats which is x% of the highest 40
click 'add data labels'
right click the bar again
click 'edit data labels'
click ' numbers'
select 'percentage'
Edit: huh word o0
Not even for friggin me! "Yeah sure that should be simple enough...." two hours later :l