I have a yearly workbook containing monthy data (1 worksheet per month)
I need to create one chart within the same workbook, showing the yearly result, using data from the other worksheets. Is this possible? I'm not sure how to reference data from worksheets other than the sheet that the chart is on.
Any help would be appreciated.
I need to create one chart within the same workbook, showing the yearly result, using data from the other worksheets. Is this possible? I'm not sure how to reference data from worksheets other than the sheet that the chart is on.
Any help would be appreciated.