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