Coding to Create similar charts for Range of coloumns

Hello all,

I have about 50 columns I would like to make identical charts for, with different data based on the column. I am a VBA noob, and this is way beyond my abilities. So first off, I don't even know If it's possible.

However, I have a sneaking suspicion one of you smart fellows out there one excelforum.com knows how to solve my problem.

Anyways, back to my problem. I would like a code such that I can do it all once, and then "drag" the chart across to all the columns (i.e. have the chart code in a while loop for a range of columns). The attached sheet 2 posts down shows information on two tabs and shows the example chart something similar to what I would like. I would also like to position the chart and reletave to a cell in the coloumn while making the cahrt the same width as the column.

You will notice I used X error bars to make lines for my LCL,CL,and UCL control limits. I am sure there is a more elegant way to make a line from a single datapoint.


Thanks in advance!

See below.