Creating a Dashboard in Excel

Copper Contributor

Hello,

 

I have a backlog of tasks from different teams (Accounting, reporting, etc), and I'm looking to create a more efficient way to display the high level status of all the tasks. I'm thinking that a dashboard with different charts displaying who the task is with, expected dates/timeline for the tasks, etc, would be a good way to show this information. It would be more efficient to have one page in which I can filter the charts to display the tasks by the different teams, or show all them together. Does anyone have any tips or videos showing how to do this?

1 Reply

Hi Stephen,

 

Lot of materials, e.g. this one https://www.youtube.com/watch?v=RM8T1eYBjQY with filtering