Previous Topic Next Topic

Query on developing table and chart automatically

Closed
machoman4lyf Posts 4 Registration date Sunday March 18, 2018 Status Member Last seen April 13, 2018 - Apr 13, 2018 at 10:47 AM
 Blocked Profile - Apr 13, 2018 at 04:21 PM
Hello,
Please guide me how to develop a table & chart automatically based on the below input data.

I am able to develop table and chart manually for the set value , but incase user changes the input value then table and chart should also change as per
the set number of years.

INPUT DATA:

A B

1 years 10

2 starting value 1000$

3 Interest rate 10%

I am looking for output as per below screenshot , kindly guide.




excel file https://files.fm/u/qqdbg58b

1 response

Answer 1 / 1
Blocked Profile
Apr 13, 2018 at 04:21 PM
Take a look here:
https://support.microsoft.com/en-us/office/update-the-data-in-an-existing-chart-9776678e-c608-4a7c-9679-5c70e374f9be?ui=en-us&rs=en-us&ad=us