I have created a Exchange Rate Chart. And there is a option to select to see the flow for 1 week ago, 1 month ago, 1 year ago and 2 year ago (Period). The main data table is last updated at 05/03/2017 and i have created another tab which will generate the list of rate when the Currency and Period is chosen. Hence i use a Name to define the Data Range (in my excel, its call Chart2). WHen i set my Data Range to Chart2, it work perfectly in my PC. However, when i send to other people. Somehow, the Chart2 don't seems to automatically update unless the person manually key in Chart2 into the Data Range. And even so, when that person, click on a different period. The Data Range go wrong again.
I have attached the sample. Can anyone tell me whats wrong with it? Or is there any way to Generate the Chart right from the Main Data Table?
Bookmarks