Excel: Selecting a Single Data Point on a Chart

ID: Q67477


The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, 4.0


SUMMARY

In Excel 3.0 and 4.0, to select a single point in a chart, hold down the COMMAND key and click the point with the mouse.

In Excel 2.20 or earlier, you can select a single point if there is only one series in the Main chart or only one series in the Overlay chart. If this is the case, click the point with the mouse.


MORE INFORMATION

Excel 3.0 and 4.0 allow you to select a single point regardless of how many series are in the chart. If the COMMAND key is not held down, clicking a single point will highlight the entire series (even if it is the only series on the chart). When holding down the COMMAND key, only the point clicked with the mouse is highlighted.

In Excel 2.20 and earlier, you can select a single point in the chart only if that point is in the only series in the chart. If there are two series on the chart, an Overlay must be created if you want to select a single point. With three or more series, you can click only a single point on one of the series, and only by making that series the only series in either the Overlay or the Main chart.


REFERENCES

For more information on selecting a point, see pages 435-438 of the "Microsoft Excel User's Guide 1" for version 4.0 or pages 435-438 of the "Microsoft Excel User's Guide," for version 3.0.

Additional query words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.2 2.20 3.0 4.00

Keywords :
Version :
Platform :
Issue type :


Last Reviewed: March 21, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.