vba code to restrict horizontal categories items repetition

Hi

I have chart as shown in attached file. It plots 12 months data.

I want to restrict it to plot only such number of months as is mentioned in Cell H1.

Thank you

Is there no solution to this problem?

This may work for this one..

Please Login or Register  to view this content.

Thank you Gerard, it works superbly but I want to move the cells H1 to some other sheet, say sheet xyz.

Then what will be change in the code

put this in the sheet you want to make the choise (H1 in this case)

Please Login or Register  to view this content.