+ Reply to Thread
Results 1 to 3 of 3

Automatically update a graph each time worksheet is updated

  1. #1
    Registered User
    Join Date
    09-08-2014
    Location
    Castlebar, Ireland
    MS-Off Ver
    windows 10/Excel 2019
    Posts
    79

    Automatically update a graph each time worksheet is updated

    I have a training record for team members that they update periodically and that shows the percentage of training complete. I would like to update my graph automatically to monitor progress every time their training percentage increases without having to save a separately dated sheet each time.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: Automatically update a graph each time worksheet is updated

    Just keep entering your data (like in cells G1 to K2)
    Then click anywhere in the chart itself and your data A1 to F2 should be highlighted in blue and purple.
    Move your mouse at the very end of your data and your mouse pointer should change to lines with arrows on both ends
    Then simply drag the mouse over into your new data.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-08-2014
    Location
    Castlebar, Ireland
    MS-Off Ver
    windows 10/Excel 2019
    Posts
    79

    Re: Automatically update a graph each time worksheet is updated

    The problem I have is that is that the individual team members update their training sheets as they go, that is linked to the supervisors sheet which I attached and although the supervisor can see for example when he looks at his sheet today he will see Team Member A has 10% training complete in the Column marked "overall" when he checks back in a month it may read 50 but I would like to plot the progress on a graph so we can see when the Team members sheet was updated. Apologies if not explaining this very well.

+ 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. Calculated Field to update automatically when Pivot is Updated
    By Aoleone# in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-05-2019, 09:24 AM
  2. Update Date Time when cell values change/updated
    By thanhthinh1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2018, 10:35 AM
  3. Graph or chart to be updated automatically with new data
    By sumonrezadu in forum Excel General
    Replies: 0
    Last Post: 11-06-2012, 08:32 PM
  4. Replies: 0
    Last Post: 04-11-2011, 12:01 PM
  5. Update worksheets automatically when Master Sheet is updated
    By ApothecaryFairy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-04-2008, 01:43 PM
  6. Replies: 1
    Last Post: 10-04-2007, 02:26 AM
  7. date and time updated automatically
    By Richard in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-05-2006, 12:55 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