Hello everyone
I have been scratching my head over this most of the day.
I have developed a great project summary report which provides the user with several useful charts, auto filters, etc from raw data.
My challenge is this, I have created a chart that offsets its data using the Offset formula and name manager, there could be any number of rows of data and I only want to see actual populated rows. which I have done, and this works exactly how I want it to.... However when I copy and paste the whole worksheet, it seems to lose the offset functionality and only returns the rows used from the original copied sheet for example Original chart has 15 rows of data, copy has either 6 rows or 24 rows and it shows either 6 rows of data and 9 blank rows or the first 15 rows not the full 24.
I am quite experienced user of excel and formulas but relatively new to Name Manager and Dynamic charts.
When I add the offset reference into the Name manager I have tried to scope both Workbook and template sheet but neither seem to work
If anyone can advise me where I am going wrong I would really appreciate.
Many Thanks in advance
Si
I have been scratching my head over this most of the day.
I have developed a great project summary report which provides the user with several useful charts, auto filters, etc from raw data.
My challenge is this, I have created a chart that offsets its data using the Offset formula and name manager, there could be any number of rows of data and I only want to see actual populated rows. which I have done, and this works exactly how I want it to.... However when I copy and paste the whole worksheet, it seems to lose the offset functionality and only returns the rows used from the original copied sheet for example Original chart has 15 rows of data, copy has either 6 rows or 24 rows and it shows either 6 rows of data and 9 blank rows or the first 15 rows not the full 24.
I am quite experienced user of excel and formulas but relatively new to Name Manager and Dynamic charts.
When I add the offset reference into the Name manager I have tried to scope both Workbook and template sheet but neither seem to work
If anyone can advise me where I am going wrong I would really appreciate.
Many Thanks in advance
Si