Results 1 to 4 of 4

Chart based on Named Range which changes size

Threaded View

  1. 06-09-2017, 11:08 AM #3
    LynnF
    LynnF is offline
    Registered User
    Join Date
    06-09-2017
    Location
    Ireland
    MS-Off Ver
    Office 2010
    Posts
    3

    Re: Chart based on Named Range which changes size

    Thanks, See attached sample spread sheet. When Overall is selected it should appear as it is in the spread sheet. When NCB is selected it should appear like the attached image. The correct Chart Data Range is =Results!ResultsRange
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Named formula (dynamic named range) used in chart SERIES may not begin with C or R
    By 6StringJazzer in forum Tips and Tutorials
    Replies: 0
    Last Post: 03-08-2016, 02:25 PM
  2. Macro to copy named range "box" values to named range "box2". Both are size of 5x26
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2011, 10:56 AM
  3. chart title based on Named Range
    By Hammer_757 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-05-2009, 07:34 PM
  4. [SOLVED] Changing a named ranged based on array size on a form
    By Wanderer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2006, 08:15 AM
  5. [SOLVED] inserting a named range into new cells based on a named cell
    By Peter S. in forum Excel General
    Replies: 1
    Last Post: 06-03-2006, 10:55 PM
  6. increasing the size of a named range and saving it back to the spreadsheetI
    By ross_smith@csaa.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2006, 07:10 PM
  7. Cannot Expand Named Range - when size of the Range exceeds
    By Snig in forum Excel General
    Replies: 1
    Last Post: 07-07-2005, 09:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1