| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Single trendline for multiple series
I have a chart with 2 different series of data graphed. I would like to have
1 single trendline for both of the series. Is there a way to do this? Thanks. -Mark |
|
#2
|
|||
|
|||
|
MAWII wrote:
I have a chart with 2 different series of data graphed. I would like to have 1 single trendline for both of the series. Is there a way to do this? Thanks. -Mark Personally, I'd combine the data sets into a single one in a third helper column. You can then plot that and put a trendline through it. By judiciously picking colors and such you won't see the third data set on the plot -- just the first two and the trendline. Good luck... Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trendline and multiple data series | Excel Discussion (Misc queries) | |||
| Error bars for a single data point not whole series | Charts and Charting in Excel | |||
| How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
| series graph -- one series being added to another series | Charts and Charting in Excel | |||
| How do I get a trendline for all data series, instead of just one. | Charts and Charting in Excel | |||
Linear Mode
