Hello,
I have the following problem.
I want to change the time scale in a chart (XY scatter) by changing the dates in another worksheet. In other words, I have a chart showing the results from 1 January 2005 up to 31 January 2005. Now I want to see in more detail the results in the chart from 8 January 2005 up to 12 January 2005. I do not want to do this by double clicking the x-axis and then change the scale, but just by changing the date in a worksheet. So in a worksheet I have a box with start date = .... and end date = ..... now the scale of the chart has to change according to the values I fill in the box in the worksheet. I hope this is clear. If somebody can help me, I am very happy. Thank you in advance.
Regards,
Niels
Bookmarks