+ Reply to Thread
Results 1 to 4 of 4

How to get Excel charts to update automatically?

  1. #1
    Registered User
    Join Date
    06-18-2014
    Location
    Scotland
    MS-Off Ver
    2010
    Posts
    19

    How to get Excel charts to update automatically?

    I have a simple table created in excel. I can create the table and have done so. I have some data inputted but I want to continue to input data each month. Why won't my table automatically populate the new data into the table immediately?

    example.jpg

    Any help would be gratefully received!




    Thanks Ewan! :O)
    Last edited by Laingy24; 04-19-2015 at 07:06 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: How to get Excel charts to update automatically?

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    06-18-2014
    Location
    Scotland
    MS-Off Ver
    2010
    Posts
    19

    Re: How to get Excel charts to update automatically?

    Hello Glenn,

    Many thanks for looking at this for me. I would like to know how to do this for myself as I have multiple cases that I need to do the same thing for.

    Your help is greatly appreciated.

    Ewan.

    Example.xlsx

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: How to get Excel charts to update automatically?

    You haven't done anything "wrong". It's just that low values aren't easily seen on a 3D chart. See example on left (chart options/design/change chart type). Compare with the original. I'd also be tempted to put in the rest of the months of the year for a consistent appearrance. the 3D options can be adjusted to tase at Chart options/format/3D view.
    Attached Files Attached Files

+ 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. [SOLVED] Automatically Update Charts (Dynamic Ranges?)
    By nobodyukno in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-16-2013, 09:20 PM
  2. Replies: 3
    Last Post: 05-20-2013, 04:21 PM
  3. Unable to update SPC charts automatically
    By ryan.carr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2012, 05:33 PM
  4. automatically update charts
    By slimjen in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-04-2007, 06:25 PM
  5. [SOLVED] Automatically update charts for only the most current 12 months?
    By AIEC33 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-27-2006, 11:35 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