Posted by Kristen on November 28, 2000 10:55 AM
I am TRYING to create scatter charts that have 2 red lines drawn in horizontally using the Draw tool to set a data range. For example I need have a PH balance chart and the readings should be between 8.8-9.5 so I drew a red line across the chart at the 8.8 mark and the 9.5 mark so that correct readings fall between the lines. I was wondering if there is any Macro or VBA script to insert these lines for me. Is this even POSSIBLE???? If not I think it should be a suggestion in future versions! Any information you can provide would be GREAT!