I am trying to use combo boxes to pull data from a raw data sheet with an intention of drawing a bar chart from it. The source data is 28000 rows so creating a chart from all of it is bogging my system down.
excel.png
When I select 2006 from the combo box it draws the first record it comes across. When I select values from the 2 other comboboxes I cannot get E3:Q3 to reflect this.
Is there any way of doing this easier?
Bookmarks