Tue 3 Jul 2007, 12:51Delegate Will said...
Will has attended:
Excel Intermediate course
Excel Advanced course
Charts
Why when you highlight the 'dots' on a scatter graph before plotting a line through the 'dots' does it not highlight all the dots. Also, does this mean that they are not being included in the calculation of where to plot the line.
Tue 10 Jul 2007, 12:50Trainer Anthony said...
RE: Charts
Hi Will. In all liklihood if all the dots aren't being highlighted they are comprised of different data series, in which case they won't be part of an overall calculation such as a trendline. Look at your source data and make sure your data is separated into discrete chunks, and then re-plot.
