auto-expanding chart- dynamic ranges

  • Thread starter Thread starter winewoman
  • Start date Start date
W

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dynamic range and chart - big help!! 3
Auto expanding charts 3
Chart SERIES OFFSET 3
PivotTable auto-refresh with external data 4
URGENT: Using Named Ranges with Chart Wizard 4
Finding the weighted average of text that have been given values 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Issue with dynamic chart mapping out blank info 6

Back
Top