cruizectrl
Vendor
Its me again with the 52 worksheet nightmare.
I'm trying to create graphs on my report pages to reflect the totals per week 1-52.
The only problem is the range is one single cell (the total) spread out from worksheet 1 to 52 and excel keeps returning an error. Each graph is going to have 5 lines spreading along the 52 weeks while refelcting the totals given for each cell in each worksheet. It needs to be dynamic so when the totals change or are figured as the weeks go by the graph will update along with it.
Hope this is enough information.
I'm trying to create graphs on my report pages to reflect the totals per week 1-52.
The only problem is the range is one single cell (the total) spread out from worksheet 1 to 52 and excel keeps returning an error. Each graph is going to have 5 lines spreading along the 52 weeks while refelcting the totals given for each cell in each worksheet. It needs to be dynamic so when the totals change or are figured as the weeks go by the graph will update along with it.
Hope this is enough information.