I am new to this site but am certainly glad I found it! I have used the
offset and count functions in my formula to adjust my chart which is set in
my pivot table so naturally the data will change as a different filter is
set. I have gone to Stephen bullen's funchart1.xls... great source!
Obviously I am missing something, my chart isn't updating. I have inserted
the formulas into my chart as well. I would like to post my spreadsheet, is
that possible?

thanks,Cindy