You don't necessarily need VBA. Use a combo as in the example below to
select a month:

http://peltiertech.com/Excel/Charts/ChartByControl.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"ETLahrs" wrote in message
...
I have a spreadsheet that totals errors for every employee daily and then
sums them by month and year to date. Instead of having 13 charts (1 for
each
month and a ytd), I have created a combobox with a list of the months and
ytd
and would like to have 1 chart that would change its source data based on
the
month that is selected.

The problem I think I am having is setting the range. The numbers are in
a
row, but not consective...so January's data is all row 28 but the columns
are
D, G, J, M, P, S, V. I am not sure, but because of this I don't know if I
can use:

ActiveChart.SetSourceData Source:=Sheets("Totals").Range("D28", "G28",
etc. )

Thank You for any help.