I have many similar worksheets (similar data table formats) within a workbook. I also have created only one chart to show the data (multiple series) for ONE particular worksheet.
Q1. Are there any tricks that requires a simple change of one cell content (with the cell storing the worksheet name), and then the chart would plot the data of the corresponding worksheet accordingly?
Thanks
Richard
