Hello,

I have a workbook, it has data with identical formating on each worksheet. I would like to plot charts from this workbook as follows

X axis reference columnA from any worksheet (because this column is adentical)
Y axis references for series 1-6 will be column B to FT for worksheets 1-6 respectively

I would like to plot one chart for every set of columns (~ 149 charts)

I dread doing it manually, is there some way to write some program or macro for it?

really appreciate any help.