On Fri, 20 Apr 2007, in microsoft.public.excel.charting,
Brad K. said:
I have a changing set of data that is 3 columns and 104 row. These are
represented on a Line Chart. I have a formula to calculate the 90th
percentile for each of these. How do I automatically put a horizontal line
on the chart for each of the three measurement at the corresponding 90th
percentile.

Create three more columns, each with the 90th percentile value in it
repeated down all 104 rows.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.