Consulting

Results 1 to 2 of 2

Thread: How to update a graph automatically based on formulas in a table

  1. #1
    VBAX Mentor
    Joined
    Aug 2010
    Posts
    457
    Location

    How to update a graph automatically based on formulas in a table

    I have created a table with different figures that are graphically represented on a bar chart. What I'd like to achieve is when a figure is entered into my dashboard or self created table with formulaes that relates to the graph, the figure automatically updates the graph, as well as the new entered figures will automatically populate on the table. Can an expert explain to me how this can be done? I'm not sure if I will need to use visual basic to do this...if so, do you know any good code to handle this interesting problem.


    Thanks

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Surely, if your graphs are sourced from the dashboard it does update automatically.

    How about posting the workbook and point out the actual cells.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •