X Axis not charting properly

Hello All,

I have a macro that charts data for me. Everything about the macro works with 1 exception: I want to redesignate the x-axis labels. The macro does do this but it doesn't do it right. In some cases it frame shifts the categories, in others it labels a category completely wrong. I have attached a sample workbook to better illustrate what I am saying. The charts are on the sample tab, the "Charts" tab is included in case you'd like to run the macro yourself. The macro is supposed to chart the data by product ID (one chart per product ID) and then change the x-axis category to the label in column F on "Chart Data."

Thanks, in advance, for your help.

Sample Data4.xlsm

Below is the part of the macro that creates the charts and subsequently changes the x axis:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

You're welcome