| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Line Width in Line or Scatter Chart | Charts and Charting in Excel | |||
| Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
| How to add a Vertical Line to a Column or Line Chart with two axes already in use? | Charts and Charting in Excel | |||
| Chart Type - Line Column adding a 2nd line | Charts and Charting in Excel | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
Linear Mode
