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? |
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 |
All times are GMT +1. The time now is 08:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com