View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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.