I came across a thread which was very helpful in helping me to create my first drop down list linked to a chart. I have
succeeded in getting the title and legend of the chart to update with changes in selection of the drop down list. However,
I have not succeeded in setting the macro up correctly (see error below) to select the data for the "StoreNo"
string which is selected from the drop down list. I have attached my spreadsheet as well so you can see what I am trying to
I am new with creating macros and would appreciate your help in correcting the macro to get this up and
running.ANNUAL USAGE BY STORE 2009 - 2011 - DRAFT WITH ERRORS FOR HELP.xlsx
Also, I am very interested in learning
to write macros for excel to assist in the many analysis reports our customers request so I would appreciate direction for a
good curriculm (online is my preference but a book would work as well).
' Macro4 Macro
Dim StoreNo As String
Dim FindStore As Range
StoreNo = Range("H1").Value
On Error Resume Next
With Sheets("CHART BY STORE")
Set FindStore = .Columns(1).Find(What:=StoreNo, After:=.Cells(1, 1), LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
On Error GoTo 0
If FindStore Is Nothing Then
MsgBox "Team Not Found"
Application.Goto FindStore, True
ActiveChart.SetSourceData Source:=Range("B" & ActiveCell.Row, "D" & ActiveCell.Row)
ActiveChart.SeriesCollection(1).Name = "=CHART BY STORE!$A$" & ActiveCell.Row
ActiveChart.SeriesCollection(1).XValues = "=CHART BY STORE!$B$2:$D$2"