Home |
Search |
Today's Posts |
#1
|
|||
|
|||
trendlines
I have one graph (x,y scatter) with 8 series (plots) on it. I want to assign
a trendline but it only gives a trendline for that series. Is there a way of assigning a trendline to give a best fit for all the points in all 8 series? any feedback would be much appreciated A. Gray |
#2
|
|||
|
|||
In the XL world a trendline only applies to one series. You can create
multiple trendlines, one per series. Alternatively, plot all the data as a single series and create a trendline for this composite series. If you want the chart looking like it does now, add the composite series to the chart and format it to be invisible. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have one graph (x,y scatter) with 8 series (plots) on it. I want to assign a trendline but it only gives a trendline for that series. Is there a way of assigning a trendline to give a best fit for all the points in all 8 series? any feedback would be much appreciated A. Gray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trendlines for two phases | Charts and Charting in Excel | |||
When and Why Trendlines may not be calculated correctly? | Charts and Charting in Excel | |||
Trendlines to ignore empty cells | Charts and Charting in Excel | |||
Summing trendlines in excel charts? | Excel Discussion (Misc queries) | |||
Short trendlines? | Charts and Charting in Excel |