Hello,
I have several people I chart their number of calls made on a daily basis.
Each person has his/her own worksheet.
I have named the totals I want to chart as named ranges (i.e. Week1,
Week2...)
I have also created a list using insert.name/paste/paste list to create a
drop down list of all the named ranges.

I have used the macro recorder to record making the chart but every time I
try to change the chart range to the named range I get an error.

I would like to be able to use the selection in the dropdown list to create
a chart from VBA.
Can anyone point me to a KB article or does someone already have something
like this they might share.
Thanks
James