90% line across line chart

[Guest]

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

 

[Del Cotter]

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.

 

[Guest]

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%.

 

[Jon Peltier]

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

- Jon