Create a chart

[tforthofer]

Hi,

I'm not sure if this is possible but I'm creating a workbook that as over 1,000 sheets and in those sheets I have data that I would like to make into a chart. I was going to use the select all sheets option and use a Master sheet update tab to create the data but the option is grayed out. Does anyone have any idea how I can do this?

Thanks,

Tim

 

[oldbrewer]

so your chart will have a minimum of 1000 data points ?

 

[tforthofer]

Sorry wasn't quite clear. I have over 1000 worksheets. Each chart would have about 48 data points per worksheet.