|
|||||||||||||||||||||
|
#1
|
|||
|
|||
|
Dynamic Chart DataSource in XL07
Hi,
I'm trying to create a dynamic DS for a chart in Excel 2007. it won't accept named ranges (it automatically converts them to ranges, so any chages to the named range is not reflected..) it won't accept Offset formula (or any other that i tried). i can resolve it by code (change event and setting new ds..) but i'd like not to do that. i can also use formulas in the ds table - but then i get blank columns in the chart and I don't want that either... any ideas?? thanks!! Yonyon |
![]() |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Dynamic Normalization Chart ? | impala096 | Excel Charting | 4 | 03-28-2008 04:36 PM |
| XY chart dynamic range problem | schnett | Excel Charting | 1 | 10-01-2007 04:11 PM |
| dynamic chart with VBA code | weii | Excel Charting | 3 | 09-15-2007 09:04 AM |
| dynamic chart | icupat | Excel Charting | 1 | 06-01-2007 06:50 PM |
| Dynamic Chart | Grek | Excel Programming | 4 | 09-28-2006 01:29 PM |