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/yas...port_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.