+ Reply to Thread
Results 1 to 2 of 2

Chart not picking up named range

  1. #1
    Registered User
    Join Date
    06-22-2010
    Location
    Airdrie, Scotland
    MS-Off Ver
    365
    Posts
    42

    Chart not picking up named range

    Hi,

    I am trying to create a dynamic chart sourcing all of the data from a named range. I've named the range using the OFFSET method and, having tested it, it dynamically updates when the data is altered. I have tried to use this as the source for my chart (i.e. chart data range = 'sheet1'!NamedRange) but every time the data changes the chart looses the named range and does not update. Is there something further I should be doing in order for the chart to update?

    TIA,

    Alan.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,726

    Re: Chart not picking up named range

    There are bit of quirks, using dynamic named ranges in a chart.

    IIR, there are cases when you needed Workbook name reference as well when used in data series. But it's been a while since I used named range to build charts.

    Try following tutorial in links. And see if that works for you.
    https://chandoo.org/wp/dynamic-chart-data-series/
    https://www.techrepublic.com/blog/mi...arts-in-excel/
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 03-08-2016, 02:25 PM
  2. [SOLVED] Named Range in a chart.
    By revenge4ash8 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-15-2014, 08:30 AM
  3. Dynamic Named Range Picking up Cells with Zeros (0s)
    By bjnockle in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-06-2014, 01:59 PM
  4. Automatically picking chart range in a column
    By artmak in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-06-2014, 03:29 AM
  5. picking cell from named range passed to vba
    By toddah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2011, 11:49 PM
  6. Named Range In Chart
    By simmo86 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-26-2009, 07:44 AM
  7. [SOLVED] Can I use named range in data range box when creating pie chart?
    By BJackson in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-17-2005, 01:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1