timfrey1
New member
- Joined
- Feb 16, 2021
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Microsoft Excel for Office 360
(My first post)
In VBA I created a chart with 2 sets of data and added trendlines with automatic display of the equations and R-square values. However VBA always put the equations and R-square on top of each other and When I manually separate them I am not sure which trendline equation goes with which set of data, especially if the 2 sets of data are fairly similar. Subtle equation coefficients are critical to my analysis. Is there anyway I can move the first trendline equation before the second trendline equation is put on the graph? Thanks in advance for any reply. Stay safe!
In VBA I created a chart with 2 sets of data and added trendlines with automatic display of the equations and R-square values. However VBA always put the equations and R-square on top of each other and When I manually separate them I am not sure which trendline equation goes with which set of data, especially if the 2 sets of data are fairly similar. Subtle equation coefficients are critical to my analysis. Is there anyway I can move the first trendline equation before the second trendline equation is put on the graph? Thanks in advance for any reply. Stay safe!