Adding/Viewing Trendlines to Charts

C

cruehle

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!
 
T

Tushar Mehta

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

--
Regards,

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

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trendlines: When They Will Be Generated, And When They Will Not BeFor A Scatter Chart 0
Unintended line connecting two data points 0
Trendline Not Appearing In Chart Problem ? 0
Trendline in Stacked Column Chart 2
Trendline Showing Problem ? 3
Extrapolation of x value from the trendline of a non-linear graph 1
Trendline partial data 2
Sr. Citizen Question On Adding A Trendline, Please ? 1

Top