Two Q's: Charting resources? and Easy manipulation of chart source data?

[JoshuaSQ]

I have two questions, the first and more general question is: Are there any good resources (i.e., websites) that discuss more intermediate to advanced charting topics? (any that happen to touch on my next question would be specifically helpful).

Second question:
I am in a situation where i will be making MANY frequency charts. They should all be very similar except that they will use a different column of data and have a different name. Is there a way to easily adjust the source data without going through the process of right clicking, selecting source data, editing each element that needs to change.

can indirects be used in charts?

thanks in advance

Josh

[Andy Pope]

Resources,
http://peltiertech.com/Excel/chartlinks.html

Manually you can select the series and then reposition the bounding areas over different ranges.

You can not use formula directly but you can use named ranges.

There is always VBA to speed up repeative tasks.