dynamic date range for scatterplot chart

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.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
I import the data using MS Query & date Parameters (from a hidden sheet), then bounce the chart title from the dates (filter dates - user selected)

A2 & B2 being the user selected dates

EG -

="Period Selected : " & TEXT(A2, "dd mmmm yyyy") &" - " & TEXT(B2, "dd mmmm yyyy")

As the dates change, so does the chart & the chart title
 

clayv

New Member
Joined
Sep 18, 2006
Messages
6
If you use named ranges you can do this by update the min and max values in 2 cells. But the named range formula is pretty complicated (e.g. OFFSET(Sheet1!$A$3,MATCH(Sheet1!$E$1,Sheet1!$A$3:$A$13,0)-1,0,MATCH(Sheet1!$E$2,Sheet1!$A$3:$A$13,0)-MATCH(Sheet1!$E$1,Sheet1!$A$3:$A$13,0)+1,1) )

So, if you'd like a sample workbook PM me and I can send one your way.
 

Forum statistics

Threads
1,141,588
Messages
5,707,264
Members
421,498
Latest member
matinebi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top