Ok. After playing with it some more...The sheet was protected. When I
unprotected the sheet the graphs are ok. When I protect the sheet, the scale
locks up and does not change. This had nothing to do with the hidden columns.
I guess it was the protection that was messing it up. How can I protect the
sheet and still make the charts work.

"tpgexcel" wrote:

I need to add one more thing. The cells being referred to in the code are
hidden in the report. When I unhide those columns the chart works fine, when
I hide them the scale dosen't work. This is frustrating.