L
LeAnne
Greetings, all -
Just thought I'd post a solution I devised for plotting a trendline for
multiple series in an XY scatter chart. I wanted to group my data into
different series based on category (Very Good, Good, Fair, Poor, and
Very Poor) so I could color-code the dot markers on my XY Chart.
However, the Chart > Add Trendline option would only allow me to select
one data series at a time. But I found a simple solution which worked
well in my case. After charting the X-Y values for each category, I then
added another series to my chart, named it "All," and inserted the cell
references for the X and Y values across all categories. Then I selected
the "All" series, added a trendline, then used Format > Selected Data
Series to render the markers in series "All" invisible (selected the
None radio button under Marker).
PS. I am using XL97. YMMV with other versions & other chart types.
Hoping this may be useful,
LeAnne
Just thought I'd post a solution I devised for plotting a trendline for
multiple series in an XY scatter chart. I wanted to group my data into
different series based on category (Very Good, Good, Fair, Poor, and
Very Poor) so I could color-code the dot markers on my XY Chart.
However, the Chart > Add Trendline option would only allow me to select
one data series at a time. But I found a simple solution which worked
well in my case. After charting the X-Y values for each category, I then
added another series to my chart, named it "All," and inserted the cell
references for the X and Y values across all categories. Then I selected
the "All" series, added a trendline, then used Format > Selected Data
Series to render the markers in series "All" invisible (selected the
None radio button under Marker).
PS. I am using XL97. YMMV with other versions & other chart types.
Hoping this may be useful,
LeAnne