You are in the classic trap where the pre set spreadsheet data does not align with the bar chart data.
The simple solution is to require anyone who is enering data on a spreadsheet to make sure it is aligned with your programme.
So set up a series of excell templates with all your programme tasks on the left column and all the data that you need to be added in columns to the right.
It may help if you set up a "task" filter before you copy paste to excell.
Then be assertive - you need the data in this format - TELL THEM otherwise no deal.
You can then copy paste the data directly into the spreadsheet side of your programme.
Member for
19 years 10 monthsHi Tipp You are in the
Hi Tipp
You are in the classic trap where the pre set spreadsheet data does not align with the bar chart data.
The simple solution is to require anyone who is enering data on a spreadsheet to make sure it is aligned with your programme.
So set up a series of excell templates with all your programme tasks on the left column and all the data that you need to be added in columns to the right.
It may help if you set up a "task" filter before you copy paste to excell.
Then be assertive - you need the data in this format - TELL THEM otherwise no deal.
You can then copy paste the data directly into the spreadsheet side of your programme.
Good luck and more power.
Best regards
Mike Testro.