VBA to create multiple charts

[NMullis]

Good afternoon,
I have attached a sample worksheet to show what I would like to accomplish. This sample shows 87 rows of data, but the actual sheet is over 9000 rows.

The data is based on a pivot table that I copied and pasted the values from then filled in the blank cells with a formula. I would like to use VBA to create the charts that are on the left of the table. As you can see the charts use the labels in F7:H7 and the data based on the same Item_No, column B. The number of rows for each data value is inconsistent, so I cannot use a relative reference to determine the starting and stopping point for each chart.

Also, if possible, I would like the chart to use the same number of rows as the data it encompasses and for the title to refer to the Item_No.

Is this possible? Any help is so very much appreciated!
N

[Andy Pope]

Try this,

Please Login or Register  to view this content.

[NMullis]

Wow, Andy this is amazing! I wish I had even 1/10 of your VBA knowledge!

Thank you!
N