+ Reply to Thread
Results 1 to 6 of 6

Chart does not update

  1. #1
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Chart does not update

    I am using Msgbox to ask the user if data input that links to a chart must be cleared. If the user selects "Yes", data is cleared but the chart displays as if the data was not deleted. The chart only updates once all the input has been entered. How can I update the chart as soon as the user selects "Yes" ? I think I need code before "End If"?

    Please Login or Register  to view this content.
    Thanks in advance

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Chart does not update

    It does for me in a mock up workbook.
    Perhaps if you could post your workbook here it would help us diagnose the problem.

    BSB

  3. #3
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Re: Chart does not update

    Thanks for your reply. After the MsgBox runs, I use 4 InputBoxe's to collect information. The chart does not change during collection of data from Inputbox although the data has cleared? Once the user clicks "Yes" to clear input data, I expect the chart to change but it does not?
    Thanks in advance

  4. #4
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Re: Chart does not update

    If I manually delete data, the chart responds correctly - is there code to re-set the chart once the user selects "Yes" from MsgBox?

  5. #5
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Chart does not update

    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 then scroll down to Manage Attachments to open the upload window.

    BSB

  6. #6
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Re: Chart does not update

    Thank you - I have attached sample file.
    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. Update all chart x axis in workbook according to a specific "master chart" VBA query
    By synchrotron in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2015, 06:00 AM
  2. Transfer/update columns from 1 sheet to another + update chart & data selection
    By Julien355 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2015, 11:54 PM
  3. Update Chart Title using slicer to filter chart
    By redil855 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2014, 10:18 AM
  4. Auo-update chart?
    By JonathanB2 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-01-2013, 08:51 AM
  5. Chart not updated until chart sheet opened following source data update
    By untilyesterday in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-24-2013, 12:27 PM
  6. Chart Update
    By _darkness in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 11-03-2008, 09:14 AM
  7. [SOLVED] Do not update chart
    By Prixton in forum Excel General
    Replies: 2
    Last Post: 09-22-2005, 03: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