My colleague and fellow MVP Debra Dalgleish shows a dynamic chart approach that lets you Select Excel Chart Dates From a Drop Down List.
Debra has provided her usual comprehensive step-by-step instructions and an example workbook you can download. Her example was done in Excel 2007, but it works as well in previous versions.
Debra contributed the first Dynamic Chart example on my fledgling web site, back when it was still just a hobby on GeoCities.
Here are more dynamic chart tutorials I’ve written:
- On the Peltier Tech Blog
- Dynamic Charts
- Dynamic Chart using Pivot Table and Range Names
- Dynamic Chart using Pivot Table and VBA
- Dynamic Ranges to Find and Plot Desired Columns
- Split Data Range into Multiple Chart Series without VBA
- VBA to Split Data Range into Multiple Chart Series
- Dynamic Chart Source Data (VBA)
- Dynamic Chart with Multiple Series
- On the Peltier Tech web site
- Published in TechTrax ezine
- Dynamic Charting By Dates
Randy says
Hello, excellent topic and I am using the same for my dynamic chart dates. However I have a unique twist I cant figure out. My data is 1 min stock data. Example: 2016-02-08 9:30, 2016-02-08 9:31, etc to 16:00 when the stock market closes. So for 1 day my drop down list has already 390 entries, if I add 3 month of data my drop down list is endless. I want to be able to have my list only show date no time such as 2016-02-07, 2016-02-08, etc. When I select start and end dates of say from the last sentence I would like to get my chart to show 2 days of data on chart of 390 x 2 days so 780 data points. Any suggestions? Thanks Randy