I have a chart that is five rows and seven columns. I made a scater chart and want a single trendline for all of the data, not just a specific set.
how do I do this.
Thank you,
I have a chart that is five rows and seven columns. I made a scater chart and want a single trendline for all of the data, not just a specific set.
how do I do this.
Thank you,
Trend lines are based on a particular series.
Therefore you need to create a series using all the data, this will probably require you to duplicate the data and lay it out in a way that makes it easier to treat as a single series.
The formatting for this total series can be removed so as to not mask the separate data series.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks