+ Reply to Thread
Results 1 to 2 of 2

Updating values without updating graphs

  1. #1
    Registered User
    Join Date
    Columbus, OH
    MS-Off Ver
    Excel 2010

    Updating values without updating graphs

    I have weekly data I update, and would prefer to not have to update the graph each week. Is this possible? I tried selecting more empty cells for the graph, hoping it wouldnt graph until data was present, but am having no luck.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    MS-Off Ver
    Excel 2007

    Re: Updating values without updating graphs

    Hi Nj8988,

    Since you are using Excel 2010, I would recommend the technique that I demonstrate with a step-by-step tutorial as well as a video here:

    How-to Make Dynamic Excel Dashboard Charts Using Tables

    However, if you really want to make it complicated (but probably unnecessary based on your data), you can also use the offset method as you can also see in a step-by-step and video tutorial here:
    Case Study - Creating a Dynamic Chart in Excel Using Offset Formula


+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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