+ Reply to Thread
Results 1 to 3 of 3

Updating chart source data

  1. #1
    Registered User
    Join Date
    04-03-2009
    Location
    yorkshire
    MS-Off Ver
    Office 365
    Posts
    87

    Updating chart source data

    Hi. I have a chart that looks at a source data worksheet that is updated monthly.

    How do i get my charts to update automatically so that i do not have to edit the source and change the formula everytime?

    Thanks in advance
    Last edited by Pickygame; 10-10-2016 at 03:47 PM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Updating chart source data

    Standard answer is to create a dynamic chart that uses dynamic named ranges. You can put those terms into your favorite search engine and you should find several hits. I will include this one: http://peltiertech.com/Excel/Charts/...umnChart1.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    04-03-2009
    Location
    yorkshire
    MS-Off Ver
    Office 365
    Posts
    87

    Re: Updating chart source data

    Thank you

+ 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. Updating Pivot Source Data Automatically
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2015, 02:49 PM
  2. Updating powerpoint chart source data
    By Ram_Patel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-13-2013, 08:22 AM
  3. Updating Chart Source range during Sub optionbutton_click
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2013, 05:01 PM
  4. Replies: 6
    Last Post: 12-09-2006, 05:27 PM
  5. Replies: 4
    Last Post: 10-27-2006, 02:32 PM
  6. [SOLVED] Updating charts when data source is in a different file
    By Sarah in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-19-2006, 07:50 AM
  7. [SOLVED] updating chart source after transposing rows
    By Lynne in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-01-2006, 07:00 AM

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