Create dashboard from Excel file
Budget: $20 – $30 USD
Due date: within 12 hours.
Please see original file and sample dashboards attached. I want the dashboard in excel and google drive.
I need help creating a colorful/visual dashboard from Excel. Its a simple file that shows the customer's name and ID, the task number and the status of the ticket (open or closed).
This data will be updated daily to show reduction in open tickets so I want to be able to upload a new data file to refresh the dashboard. Create a 'click here' macro that I can click to enable data refresh breaking down the data by task number, customer name, ID, etc. For rows without customer name, 0 will populate in those tabs.
Please see original file and sample dashboards attached. I want the dashboard in excel and google drive.
I need help creating a colorful/visual dashboard from Excel. Its a simple file that shows the customer's name and ID, the task number and the status of the ticket (open or closed).
This data will be updated daily to show reduction in open tickets so I want to be able to upload a new data file to refresh the dashboard. Create a 'click here' macro that I can click to enable data refresh breaking down the data by task number, customer name, ID, etc. For rows without customer name, 0 will populate in those tabs.