I am running into a dilemma while trying to entertain my boss's demands.

I am required to create a line chart (an area still not totally known to me)
on a summary report. The chart is supposed to include a batch number on the X
axis, a test result reading on the y axis for one test performed on several
batches coming from several suppliers. So the series section (legend)
includes the supplier. As a result, the chart should draw several lines each
representing one or more reading of one or more batch of one company.

This is all well and good and have been done. The problem is that my boss
wants me to add values - in this case static - that represent the limits of
said test for comparison; adding an upper line and a lower line to the graph.
These limit values come from a table but are static per test so their line
would be a straight horizontal line. This seems to mean that I need to
squeeze in more than one data field into the series section. I have
absolutely no idea how to do that. I have tried playing with the graph
properties and design but there doesn't seem to be a way to do it.


This image shows the report wizard data layout. The CName field on the right
side of the graph is the series and where I think the limits should be added.
The fields appear on the right side. The limits are the AMin_OPC, AMax_OPC
fields which I need to display on the chart. For this test they are one
static value for the min and the max.
http://i35.photobucket.com/albums/d1...ort_wizard.jpg


This image shows the final report in its current form. All that is missing
is adding the limits.
http://i35.photobucket.com/albums/d1...101/Report.jpg

If anyone Can help, I would be eternally grateful.

Values/lines in reports are generally the result of columns in your chart Row
Source. You might need to view the Row Source in the query design and make
sure the values you want to display in the chart are columns in the query.
--
Duane Hookom
Microsoft Access MVP


"yaser101" wrote:

> I am running into a dilemma while trying to entertain my boss's demands.
>
> I am required to create a line chart (an area still not totally known to me)
> on a summary report. The chart is supposed to include a batch number on the X
> axis, a test result reading on the y axis for one test performed on several
> batches coming from several suppliers. So the series section (legend)
> includes the supplier. As a result, the chart should draw several lines each
> representing one or more reading of one or more batch of one company.
>
> This is all well and good and have been done. The problem is that my boss
> wants me to add values - in this case static - that represent the limits of
> said test for comparison; adding an upper line and a lower line to the graph.
> These limit values come from a table but are static per test so their line
> would be a straight horizontal line. This seems to mean that I need to
> squeeze in more than one data field into the series section. I have
> absolutely no idea how to do that. I have tried playing with the graph
> properties and design but there doesn't seem to be a way to do it.
>
>
> This image shows the report wizard data layout. The CName field on the right
> side of the graph is the series and where I think the limits should be added.
> The fields appear on the right side. The limits are the AMin_OPC, AMax_OPC
> fields which I need to display on the chart. For this test they are one
> static value for the min and the max.
> http://i35.photobucket.com/albums/d1...ort_wizard.jpg
>
>
> This image shows the final report in its current form. All that is missing
> is adding the limits.
> http://i35.photobucket.com/albums/d1...101/Report.jpg
>
> If anyone Can help, I would be eternally grateful.