Hey all. I have a few questions, however, I guess I should start off with the
important; Where is a good resource for learning how to program charts
effectively?

I can program Pivot tables in my sleep, but charts seem moderately more
complex and at least 10x more sensitive!!!

My main issue is utilizing the arrays to program the ranges...I cant used
named ranged or anything intuitively or dynamically as far as I can tell...I
can simply use sheetname!$A$1,sheetname!$A$2 etc etc.

Formatting doesn't appear to be very complicated, so I think I can handle
that...mainly its just working with the chart ranges...

havocdragon wrote:
Hey all. I have a few questions, however, I guess I should start off with the
important; Where is a good resource for learning how to program charts
effectively?


In my opinion, the best resources a

Jon Peltier's site: www.pelitertech.com
Andy Pope's site" www.andypope.info

--
Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca