ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   highlight individual cells for a chart (https://www.excelbanter.com/excel-discussion-misc-queries/180766-highlight-individual-cells-chart.html)

office 2007

highlight individual cells for a chart
 
I forgot how to highlight individual cells to use in a chart.

Jon Peltier

highlight individual cells for a chart
 
Select the first, then hold CTRL while selecting others. Once you have more
than a relatively small number of cells selected, the chart will no longer
accept them as input. It may be better to somehow collect the plottable data
into a single contiguous range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"office 2007" <office wrote in message
...
I forgot how to highlight individual cells to use in a chart.





All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com