on this excel sheet I have created a chart to represent the gender of my
viewers I have used the images of male and a female to graphically represent
the viewers this could easily be used on a dashboard and it's its values can be
changed so for example if I change my mail to 50% then in the 50% is
graphically represented on my chart here so let me show you how I did this I will
start a new sheet on my new chart I'm going to enter in as a decimal the
number of male viewers I have and then I'm going to select that and I'm going
to format it as a percentage and then below that what I'm going to do is I'm
going to enter in a formula and I'm going to go equals and I'm going to
enter 1 minus and I'm going to select the percent and so the 72% is the blue
part of my my chart and the 28% is the white part of my chart so this is male
now I'm going to do the same for the female so now I'm going to select those
values that we've entered and then I'm going to select insert insert tab and
I'm going to go to the charts area and I'm going to insert on the column column
charts and I'm gonna insert a stack column so now I'm going to click on my
chart and I want to change the color of the words at what's orange currently I
want to change it to white and so I'm going to select the fill color and I'm
going to make it white okay and now I'm going to check the plus sign
here and then I'm going to take out the axis and I'm going to take out the chart
title and I'm going to take got the legend and the gridlines and so
now basically we have just two bars here and so that's good and so now what I'm
going to do is I'm going to go over to PowerPoint I have opened up PowerPoint
and I've selected a blank slide now I will go to the View tab and I will click
on the check box for gridlines to add gridlines for our drawing here and now
we're going to go to the insert tab and we're going to select shapes and I'm
gonna select this rectangle here and then what I'm gonna do is I'm going to
snap it onto one of my gridlines here and go down to a boat here now what I'm
going to do is I'm going to insert a text box and it doesn't really matter
what size you make it because it will fit the size of the text that you enter
now I'm going to go to insert and I'm going to go to symbols and select
symbols again and now I have selected webdings from the types of font and now
webdings have both a male and a female so I'm gonna select the male and then
I'm gonna go insert and then I'm gonna close my dialog box so now it's very
small so let's highlight what we've just done and then when this this pop-up
dialog box comes up here we're going to key in 250 and press Enter
maybe I will make my my first dialog box a little bigger here okay so now what
we're going to do is we are going to select this figure that we've just made
and we are going to go over the box the graphic that we made here so now if you
press the control button you have your your figure already selected if you
press the control button you can click this button as well or this this box as
well so we have both selected okay so now we go to our format tab that's open
in R and we're going to drop down this merge shapes and we are going to select
combine okay now what we're going to do is we're
going to shape outline I'm going to make it blue and then what we're going to do
is shape fill I'm going to make it white so basically you have your outline of
your mail image and in a box here now I will do the same for the female now that
I have both of my images complete what I'm going to do is I'm going to select
them and I'm going to go to all control C and I'm going to go back to my excel
sheet so I've copied my two images from my PowerPoint now I'm going to put them
over top top of the chart that I've created previously and the trick is you
wait till you see white at the bottom of their feet and then bring it slightly up
from there and then you can do this you have to bring it a little bit this way
so we don't see some white at the end of his edge of his arm too tricky now it
takes a little bit to get this the practice getting this on the here and
now I'm going to take the female
do the same thing until I see white at the bottom of her feet and then bring it
up and so there you have your two graphical images of the male and female
on chart in Excel please subscribe