Auto Adjusting X Axis range based on dates

[mcranda]

I am trying to change the X axis in an Excel dashboard for 16 charts. I have reviewed many of the how to's in this forum and most of them link this address:

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

My x axis are dates: min date is found on Control sheet Cell F2, max date is found on Control sheet cell G2.
The major unit is each date that has a value between the min and max date.

Pletiertech.com has the code for chart 1. Do I use the same code 16 times for 16 charts?

Also, where does the code go? I have never used vba. Can someone give me the VBA for dummies version of peltiertech.com and how to change it for my data? Thanks.

[mcranda]

Can anyone help me?