Chart axis labels not updating properly with VBA

Hello,

I am working on a workbook where an on-page chart has to be updated depending on what the user wants to see displayed. I've attached an example of this workbook. The user would click one of the colored boxes on the left side of the page, and the means for that component, as well as means from previous periods of time would be displayed on the chart, along with the labels as to which variable they correspond with. The data and labels are being read from the second sheet in the workbook.

The data is being properly updated, but the labels do not change. If I check the data being read for the chart, it appears to be pulling over the correct labels, but unless I manually confirm the new labels, they are not displayed. The macro I am using works perfectly in Excel 2003, and was working just fine in 2007 until I copied the sheets (which I will need to do for the project I am working on).

The code is this:

Please Login or Register  to view this content.

Is there any way to force an update of the labels? I would think .Refresh would do the trick, but no such luck.

Thank you for your help.

xl2007 requires you to set the labels for all the series.

Please Login or Register  to view this content.

In xl2003 you would get away with just setting the first series.