Adding/Viewing Trendlines to Charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cruehle - 31 Dec 2003 03:21 GMT

I am working on adding a trendline to a line chart in excel. Currently,
I am using Microsoft Excel 2000. I cannot seem to view the data points
for the trendline, only the data points for the lines that I am
graphing. Any ideas on how I can get the data points on the trendline
to appear?

Thanks in advance for your advice!

---
Message posted from http://www.ExcelForum.com/

Reply to this Message

Tushar Mehta - 31 Dec 2003 11:55 GMT

A trendline doesn't have explicit data points, at least not as MS chose
to create one in an XL chart.

Signature

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> I am working on adding a trendline to a line chart in excel. Currently,
> I am using Microsoft Excel 2000. I cannot seem to view the data points
[quoted text clipped - 6 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

Jon Peltier - 31 Dec 2003 14:15 GMT

A similar question was asked a couple days ago. I suggested that the
user put selected X values into a column, and in the adjacent column use
the coefficients of the fitted trendline to compute corresponding Y values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

> A trendline doesn't have explicit data points, at least not as MS chose
> to create one in an XL chart.

Reply to this Message