One of the most important tasks in making a chart is to properly prepare
your data. One data feature that improves charting is having all plotted
cells together in a single range.

If it's not a dynamic selection of cells, you could select the cells
(use ctrl+click to select multiple discontiguous ranges), then paste
them into an empty range.

If your range is changeable, note that by default Excel charts do not
display information from hidden rows or columns. You could manually hide
rows or columns, or use the AutoFilter to hide rows.

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


micachou wrote:
I am trying to select individual cell values for my chart but the dialogue
box will only allow a certain number of characters therefore I cannot select
all the cells I want.
Help!!