When we make a graph in excel it is important to realize that just 
because excel will make a graph doesn't mean it is meaningful
Or useful.  Lets take a look at what excel creates by default
for a bar graph.  I am going to focus on the age variable
by highlighting the entire column and inserting
 a column graph, just a basic column graph.  
Notice what excel creates by default, it
creates me a graph it did what I told it to do but by default
it tells me each individual person and gives 
them a bar.  The first was 30 the second 24 etc
Essentially it is regurgitating 
the raw data and just giving it a bar instead of
a number, it is not really useful or meaningful
In the context of my report.   I want my graphs to provide more
or additional information. 
Instead what if I look at grouping people by decade? How many are 
20-29, 30-39
40-49, etc. 
You could manually and count these 
1,2,3, etc in the 30's you can even sort the 
data set to make counting easier OR
excel has a really cool tool to assist you. 
In order to do this I need my bins 
or my categories but I need only the upper
data point.  While we may write 20 to 29 
Excel wants only the upper cut off point so I am going to provide
just the upper
age for my cut off point. I will name
this age so I know what is going on. Then I am going to go up
to the data analysis tool pack and from the 
list choose the histogram option. 
Once in the histogram option you can click on the column you would like it to
create a histogram of and then highlight 
where your categories are. I am going to highlight the labels
and I will tell you why in a second.  I am going to click the
labels box, notice my column here had a label
so I want to be consistent and include a label in
the other column as well. I am going to 
click chart output because I would like excel to make me a graph. 
Excel does its thing 
and creates me a graph showing me how many
were in each category as well as
providing a frequency table so I don't have to guess, is that 26 or
27 it is somewhere in-between.  Both of these are great
 outputs and meaningful.  They 
most people are in the 20-29 age group while very few people are in the 
60-69. This provides additional meaningful 
Information and would be great to include in your report. 
Another graph you may consider is
a pie graph.  Please notice if you click on something
Like gender and I click on insert
pie graph things go awry.  
It is attempting to do the same thing or provide one 
slice of pie for each data point which isn't necessarily meaningful. 
However I can sort this out
first and determine that there are 
27 females I know this because I have already sorted it by gender
Goes down to 28, there is one row for labels. 
Since there are 50 data points total there must be 
23 males.  Now if I use the frequency
Information and include a pie chart
I have a nice meaningful picture for my data. 
Click on the chart title and give it a better name and you are good to 
go. 
