Excel 2007 Graphs - Series Formating

J

J Austin

I am creating a scatter graph from a Pivot Table sheet of values and while
all points from 4 separate series are correctly plotted, when I select a
particular series to create a least-squares line, not all points of the
series appear selected. When I select one of the points that is not properly
highlighted it does not select any other points in the series - appears to be
completed un-connected from the series.

Stumped.
 
J

Jon Peltier

Single-click once on a series, and the entire series is selected, even if
not all points are highlighted. Single click again and you will select just
the one point. When in doubt, check what is showing in the top control of
the Current Selection chunk of the Chart Tools > Layout or Chart Tools >
Format tab. Better yet, use this control to select the series.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top