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

Go Back   Excel Help Forum > Usenet Groups > Excel Charting
Setting a dynamic range for a chart Setting a dynamic range for a chart
Register FAQ Forum Rules Members List Calendar Search Today's Posts Mark Forums Read

Notices
Hi All,
The big green guy here, just wanted to let you all know that we now have the reputation system in place, the reputation system allows you to give a visible pat on the back to those that have helped you or whose information has been helpful.

You will see an icon in every post (Light Blue scales), click this to give the reputation point to whom you think deserves it, a green square appears for a reputation with more and more adding over time.Pretty soon you will see a string of green squares appear in the top right of your posts as your reputation grows and your forum presence!

Good Luck!
The Hulkster!

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 08-27-2008, 03:37 PM
dusen dusen is offline
Registered User
  
Join Date: 27 Aug 2008
Location: RI
Posts: 2
dusen is on a distinguished road
Setting a dynamic range for a chart
I have been stuck on this for a while....

I need to create a dynamic range for my chart

It should start at $M$3 and end at $T (the number that comes after "T" needs to be the number found in cell G4)

so if G4=84

the range would be $M$3:$T$84

any help would be awesome

Thanks,
Dan!
Reply With Quote
  #2  
Old 08-27-2008, 03:43 PM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Moderator
  
Join Date: 10 May 2004
Location: Essex, UK
Posts: 2,305
Andy Pope will become famous soon enough Andy Pope will become famous soon enough
Rather than specifying the complete data set for the chart you need to create a named range for each series.

Can you post example file with require chart based on static data?
__________________
Cheers
Andy
Reply With Quote
  #3  
Old 08-27-2008, 04:04 PM
dusen dusen is offline
Registered User
  
Join Date: 27 Aug 2008
Location: RI
Posts: 2
dusen is on a distinguished road
Thanks for the quick help...I can't upload the file because of a firewall...

How do i create a named range and what would the format for each of these named ranges be?

Thanks so much,
Dan

(edit)
(if you can not help without the file i compleatly understand)
Reply With Quote
  #4  
Old 08-28-2008, 05:12 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Moderator
  
Join Date: 10 May 2004
Location: Essex, UK
Posts: 2,305
Andy Pope will become famous soon enough Andy Pope will become famous soon enough
Search the forum for Dynamic ranges, there are plenty of examples.
__________________
Cheers
Andy
Reply With Quote
Reply

Bookmarks

New topics in Excel Charting

« Previous Thread | Next Thread »

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
Linear Mode Linear Mode
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 named range relating to cell values mark_jam3s Excel Programming 1 08-01-2008 07:57 AM
Chart & Data Table Range displays kostarica Excel Charting 2 06-12-2008 09:05 PM
VBA code for dynamic name range weii Excel Programming 0 09-12-2007 08:36 PM
Ignore Data for Dynamic Range dborchardt Excel Charting 1 12-08-2006 05:02 PM
Dynamic Chart Grek Excel Programming 4 09-28-2006 01:29 PM


All times are GMT -4. The time now is 06:00 PM.

Contact Us - ExcelTip.com - Archive - Top

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