Dynamic range as chart data source

  • Thread starter Thread starter BillS
  • Start date Start date
B

BillS

[Excel 97]

Is it possible, without VBA, to create a chart which will change alon
with a dynamic data source (ie a variable size range)?

It seems that if you enter a dynamic formula (or name of a dynami
range) as the data source in a chart it will accept it initially, bu
converts it to a fixed size range.

Thanks

Bil
 
You must log in or register to reply here.

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 Chart Update Issue 7
Include sheetname dynamically in named range? 2
Dynamic Axis Titles 1
Dynamic Range Names / Charting 1
Dynamic expanding chart 5
Dynamic chart -easy question that has me stuck 5
Add Item to Data List that has Dynamic Source 1
Dynamic data ranges in pivot tables 3

Back
Top