+ Reply to Thread
Results 1 to 4 of 4

Programmatically Update a Chart object

Hybrid View

  1. #1
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Smile Programmatically Update a Chart object

    I have a workbook where I have to carefully control calculation activity to only those cells and objects that need to be updated. I have a chart located on sheet1 that needs to be updated. My approach is

    Dim Cht as Object
    Set Cht = ActiveChart
    Cht.Calculate
    This generates an error. What is the preferred code here?
    Thanks in advance for any assistance
    Last edited by SDruley; 12-01-2011 at 07:56 PM.
    Turn Data into Information
    Turn Information into Knowledge
    Turn Knowledge into Direction
    Turn Direction into Leadership
    Turn Leadership into Results
    Stephen Druley

    It's not how quickly you think
    But how deeply you think
    The quality of thinking is measured
    by remoteness to conformance
    Stephen Druley

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,332

    Re: Programmatically Update a Chart object

    Charts always reflect the source cells. Calculation mode does not apply to them.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Programmatically Update a Chart object

    Sub snb()
     Sheets(1).ChartObjects(1).Chart.Refresh
    End Sub



  4. #4
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Re: Programmatically Update a Chart object

    SNB,

    This solved my problem. Thanks

    Steve

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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