sanlejushi
New Member
- Joined
- Dec 19, 2002
- Messages
- 36
Dear excel experts
for historical analysis and plotting trends, i do quite abit of charts plotting historical data, comparing different time series over particular time periods
However, each time i want to change the period i am interested in, i have to go to the X axis scale to manually key in the maximum and minimum values for X axis.
May i enquire if anyone has a faster way of changing dates, e.g such as using comboboxes to pick the starting and ending date ...not sure if this is possible, thanks.
or does anyone has a more convienient way of doing this...many thanks.
for historical analysis and plotting trends, i do quite abit of charts plotting historical data, comparing different time series over particular time periods
However, each time i want to change the period i am interested in, i have to go to the X axis scale to manually key in the maximum and minimum values for X axis.
May i enquire if anyone has a faster way of changing dates, e.g such as using comboboxes to pick the starting and ending date ...not sure if this is possible, thanks.
or does anyone has a more convienient way of doing this...many thanks.