BEN O. Follow up question PLEASEEEEEEE!!!
Posted by Kristen on December 01, 2000 5:46 AM
In reply to my post on charts and ranges your suggestion was :Instead of using the draw tool to create the lines, you could include additional data series in your charts, where all of the Y values and 8.8 for one series, and 9.5 for the other.
Once your data has been plotted, right-click on the 8.8 data series and select Format Data Series. On the Pattens tab, change the Line setting from None to Custom, and select the color red and any other settings you want. Change the Marker setting to None. Press OK and that should give you a red line across the chart at the 8.8 mark. Do the same for the 9.5 data series.
I am happy to say this worked...sort of.
what I was wondering is if there was ANY possible way to make the lines go the FULL length of the chart? It only puts a line in the middle of the chart.