Adding a trendline to a graph.... 1

[Paladyr]

Here's the problem. I want to add a trendline to a graph, but I don't want it to use ALL of the data on the graph, only a section of it in the middle. The graph I have is a bar graph, and without inserting a line object, I can figure out a way to put a trendline on there with only certain parts of the graph. Any ideas? A simple line won't work because if the scale of the graph changes the line doesn't move. Thanks for any help!

 

[SkipVought]

Paladyr,

You make a shaddow series, that only has the data points you want to trend. Add this series. Make sure that Tools/Option/Chart tab - Chart Visible Cells only.

Add trend on this series ;-)

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Paladyr]

Hm, that might work too!!! I figured it out though. I inserted a custom type graph and made a combination line/bar graph. Thanks for the reply, and I'll try that just to check it out.