Kyira L.

asked • 02/10/22

Excel trackers and dashboard

Good morning,


I need help creating a tracker in excel with a dashboard showing live data.


Thank you

Melanie P.

Hi Kyira, Ask an Expert is a platform for academic questions. Please visit our Help Center at https://support.wyzant.com/hc/en-us, and ask your question. Or let our Customer Support department help you! Contact us at [email protected] and we will follow up as soon as we can.
Report

02/10/22

Edward E.

This deserves a tutoring session instead of a question on Ask An Expert.
Report

02/11/22

EDWARD A.

I agree with Edward E, but here some general steps: Load your data. Create a pivot table from your data table to summarize and group the data as needed. Create a pivot chart based on your pivot table to visually display the data. Create a dashboard worksheet in your Excel workbook, and place your pivot chart and any other relevant visualizations on it. To make the dashboard live, use data connection features in Excel, such as Microsoft Power Query or Get & Transform Data, to connect your data source to your workbook and refresh the data automatically. Use conditional formatting to highlight important information, and add slicers to allow users to filter the data easily. To make the dashboard interactive, you can add drop-down menus, buttons, or checkboxes to allow users to switch between different data sets or control how the data is displayed. To finish, format your dashboard and add any final touches to make it visually appealing and easy to read. Note: The exact steps for creating a live tracker may vary depending on the version of Excel you are using.
Report

01/29/23

1 Expert Answer

By:

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.