auto-expanding chart- dynamic ranges

[winewoman]

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

 

[Gord Dibben]

Where did you insert the formulas into the chart?

The OFFSET....COUNT formulas are to be entered in the Refers to dialog box in
the Insert>Name Define menu.

The named ranges are to be used in the Series Formulas in the chart.

You can post the workbook at one of the hosting sites below.

http://www.freefilehosting.net/
http://savefile.com/

When you have uploaded to that site, send us a post with the URL.


Gord Dibben MS Excel MVP