ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Usenet Groups > Excel Charting

Notices

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 08-26-2008, 08:33 PM
yonyon7 yonyon7 is offline
Registered User
 
Join Date: 21 Nov 2007
Posts: 16
yonyon7 is on a distinguished road
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
Reply With Quote
  #2  
Old 08-27-2008, 06:19 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Moderator
 
Join Date: 10 May 2004
Location: Essex, UK
Posts: 2,303
Andy Pope will become famous soon enough Andy Pope will become famous soon enough
Can you post example file?
__________________
Cheers
Andy
Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

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


All times are GMT -4. The time now is 04:23 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0