Hi,
I am working on a dashboard where I am creating drop down dependent charts. For this I have used camera tool to display the picture of graphs (created in separate sheets) selected in the drop down and I am using CHOOSE function to decide the order.
The problem is all my graphs are not getting displayed, some of them doesn't show anything, but when I refresh the named ranges behind the graphs the picture gets updated in my dashboard.
Please help me in sorting out this problem.
I am working on a dashboard where I am creating drop down dependent charts. For this I have used camera tool to display the picture of graphs (created in separate sheets) selected in the drop down and I am using CHOOSE function to decide the order.
The problem is all my graphs are not getting displayed, some of them doesn't show anything, but when I refresh the named ranges behind the graphs the picture gets updated in my dashboard.
Please help me in sorting out this problem.
