auto-expanding chart- dynamic ranges
 

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

auto-expanding chart- dynamic ranges
 

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 InsertName 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

On Thu, 21 Feb 2008 10:59:00 -0800, winewoman
wrote:

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