Can I make a chart Report?

  • Thread starter Thread starter Pearl
  • Start date Start date
P

Pearl

I don't know how to work with SQL codes but can and have used the DESIGN
features in ACCESS to create forms and other simple charts. I need to
create a STACKED "monthly" bar graphs that will outline Total hours for all
the events that month and within that bar, separate each of the different
events to correspond to the hours for that event. So, if I have 3 events
(event 1, event2 and event3) and EVENT 1 was 5hrs and EVENT 2 was 3hrs and
EVENT6hrs, the single bar for the month will have a total value of 14hrs and
inside the bar will have 3 divisions. One division would be Event 1
(corresponding hrs of 5) , another would be Event 2 (corresponding hrs of 3)
and Event 3 (corresponding hrs of 6).

How can I do that without coding?

Thanks
 
Create a query that displays all of your aggregated values. I expect this
might be a crosstab query.

Then use the chart report wizard to build this for you. Select the
appropriate query as the record/row source of the chart.
 
Thanks for the advice. Actually, I had to use a pivot chart to get the
stacked graphs to work...but you gave me the idea
 
Back
Top