PDA

View Full Version : How to update a graph automatically based on formulas in a table



wedd
10-20-2010, 11:57 PM
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:thumb

Bob Phillips
10-21-2010, 12:29 AM
Surely, if your graphs are sourced from the dashboard it does update automatically.

How about posting the workbook and point out the actual cells.