muliple series selection

[Hammer_757]

When selecting a series on a chart, the source cells become outlined
the data in blue and the name in green. You can drag the borders t
modify the data, including multiply cells for the name if you wish.
This way source data can be easily modified with having to bring up th
Source Data Dialog. I would like to be able to select all the char
data in this manner so that all names and data sources are displayed a
once.

Alternately is there a way to look at all the code for a chart at once
It would make massive alterations much easier.

Thank

 

[Jon Peltier]

Hammer -

If the data comes from a well-defined worksheet range (same length
series, all beginning in the same row or column, all plotted in left to
right or top to bottom order), the entire data range will be
highlighted. It uses the same color outlines as for individual series.

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