VBA to indicate if a chart has passed or Failed

[Stevo56]

Hi,

I have a XY scatter chart that uses the plots to plot a line graph. The X Axis ranges from -5 to +5 and a Y axis that ranges from 0 to 2600. The Y axis is plotted from cell Ranges C65 to C165, the X axis is plotted from cell ranges D65 to D165. The peak of the graph (Largest value) at Y axis should be cell C115 which is 0 X axis Cell D115 in an ideal world, however I want to add in a tolerance where the Peak can be at +/- 0.5 Cells D110 to D120.
I want to use VBA to display a popup message box as "Passed" if the Y axis peak of the graph is 0 +/- 0.5 and a "Fail" message box if the peak is outside of these tolerances.

Any help would be much appreciated

Thanks in advance,
Steve
Red Graph.xlsm

[LJMetzger]

Hi Stevo56,

Nice spreadsheet design. Try the following:

Please Login or Register  to view this content.

Lewis

[Stevo56]

Thankyou so much, that worked brilliantly