I have a program with 76 charts. They all use the same range to get their
x-axis (dates). At the first of every month, I change the dates to show the
upcoming month. The table shows the entire year, but we just view it one
month (fiscal) at a time. The series is by rows, but could be changed to
columns if necessary. I inherited this program.

Currently I have to update each one of them manually (click on each and
change their XValues). Is there a way I can update all of them at one time?
Could vba be used to select and update each chart with me just selecting the
range? I am no stranger to vba, but have done very little when it comes to
charts.

Any help would be greatly appreciated.