90% line across line chart
 

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.
Thanks,
Brad

90% line across line chart
 

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.

90% line across line chart
 

Hey Brad, I recently ran in to this problem. I found a great solution and it
worked well for my graphs. Opening the Drawing tools. Draw a line anywhere on
the sheet and then follow these steps exactly.

1) Select the line and press CTRL + C
2) Select the graph you want the line on
3) Hold down shift and do not let go
4) Click on Edit in the Toolbar
5) Click Paste Picture

This stick the line in to the graph and you will be able to move it anywhere
you want and still be able to select things on the graph. You can also group
a textbox to the line and do the same thing... so you can write something
like Year to Date Goal- 90%.

"Brad K." wrote:

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.
Thanks,
Brad

90% line across line chart
 

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Brad K." wrote in message
...
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.
Thanks,
Brad