If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Assign a trendline or threshold
How do I assign and display a threshold or trendline on a chart? For
example, I would like to show an established and pre-determined threshold line to show across my bar chart to show if the data lies above or below that mark. So, it would be a straight line across rather than declining or inclining like a trendline does. I have never worked with one and I understand how the trendline can work, but do not know how to display something like this. Is this possible? |
#2
|
|||
|
|||
Assign a trendline or threshold
Hi,
Have a look at these examples for adding, threshold, lines to charts. http://peltiertech.com/Excel/Charts/RunChtLines.html http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm Cheers Andy Vicki wrote: How do I assign and display a threshold or trendline on a chart? For example, I would like to show an established and pre-determined threshold line to show across my bar chart to show if the data lies above or below that mark. So, it would be a straight line across rather than declining or inclining like a trendline does. I have never worked with one and I understand how the trendline can work, but do not know how to display something like this. Is this possible? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trendline Extract | Phil Hageman | Charts and Charting | 5 | July 6th, 2005 02:27 AM |
How do I get the trendline equation from Excel to script? | Mattias | Charts and Charting | 1 | December 7th, 2004 12:21 PM |
Trendline and its referencing / linking to a cell | MikeG | Charts and Charting | 0 | February 5th, 2004 03:17 PM |
Trendline Not The Same as Equation Displayed | Dan | Charts and Charting | 2 | January 28th, 2004 01:00 AM |
trendline equations | kathy | Charts and Charting | 5 | October 2nd, 2003 10:12 PM |