R- squared value on trend line

[Tania C]

What a help this list has been. Thanks! My last question for a while, I hope.

I have a report that has a single graph in the group header. The graph information is correct for each group, but the R2 value on the trendline is the same on each graph, and the graphs are nowhere near identical. Have a clue how to fix this?

Thanks,

Tania

___________________________________

Nevermind, I just realized that the R-squared equation does not refresh. I needed to delete it and create a new one. Hope that helps someone out in the future.

 

[GUIDO22]

I have a similar problem - the Trendline equation on the graph does not update despite changing the Rowsource for the graphobject and requerying..... any ideas please?

 

[GUIDO22]

For those of you interested - I have identified the problem ( a bug in the OLE control itself) - it seems that if you change the font colour from the default, for the trendline equation - the equation no longer updates.

Leave as the default and each time you change the rowsource setting for the graph control - the line equation also updates - which is just what I wanted!

(Above applies to the Microsoft Graph 97 Chart OLE object only)