Creating a chart on a report

  • Thread starter Thread starter Michele E
  • Start date Start date
M

Michele E

I have created a report that shows the following:
Date by Month Machine No. Sum([Rolls Made]) Sum([Standard])
(which is total expected amount of rolls to be made for a given month) and
Sum([Rolls Made]/Sum([Standard]) (which is % of Standard)

My report looks like this
Month Machine Rolls Made Standard % of Standard
April 12 24 36
66.67

I want to add a bar graph to the bottom of the report that will show the
information for the month by machine. It would have the Machine No on the
X-axis and the % of Standard on the Y-axis for each machine. My problems s
that the % of Standard for the month is calculated by dividing the sum of the
total [Rolls Made] by the sum of total [Standard}.

How can I get the graph to show the appropriate information I'd like to see?

Thanks.
 
A chart has its own Row Source which could be something like:
SELECT Format([YourDate],"yy-mm") as YearMonth,
Machine,
Sum([Rolls Made])/Sum([Standard]) as PctOfStd
FROM somewhere
GROUP BY Format([YourDate],"yy-mm"), Machine;
 
Michele E said:
I have created a report that shows the following:
Date by Month Machine No. Sum([Rolls Made]) Sum([Standard])
(which is total expected amount of rolls to be made for a given month)
and
Sum([Rolls Made]/Sum([Standard]) (which is % of Standard)

My report looks like this
Month Machine Rolls Made Standard % of
Standard
April 12 24 36
66.67

I want to add a bar graph to the bottom of the report that will show the
information for the month by machine. It would have the Machine No on the
X-axis and the % of Standard on the Y-axis for each machine. My problems s
that the % of Standard for the month is calculated by dividing the sum of
the
total [Rolls Made] by the sum of total [Standard}.

How can I get the graph to show the appropriate information I'd like to
see?

Thanks.
Click to expand...
 
Back
Top