Y
yaser101
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/d183/yaser101/Report_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/d183/yaser101/Report.jpg
If anyone Can help, I would be eternally grateful.
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/d183/yaser101/Report_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/d183/yaser101/Report.jpg
If anyone Can help, I would be eternally grateful.