View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
BrookieOU BrookieOU is offline
external usenet poster
 
Posts: 3
Default Column Chart to compare data

This is a basic question, but I'm new to charts. I have the following
information:

Hours Billable Hours Worked
9/15 121 128
9/30 159 136
10/15 133 134

I would like to make a column chart to compare the data for each pay period.
I would like the horizontal axis to list the dates. I would like each date
range to encompass two columns (Hours billable & Hours worked) for that date.
I would like to these two columns to be side by side touching. Then I would
like a small space and the next date with the two columns corresponding to
that date there.

I have figured out how to make the basic graph with all the columns
touching, but I would like to separate them out by date and I can't get the
horizontal axis to list the dates out. Any suggestions?

Thanks!