The Excel Sales Trend Dashboard

The Excel Sales Trend Dashboard lets you dump your raw sales data into a table.  This table will then automatically take your data and update the front end dashboard to show you your monthly sales trend outlining your best and worst months on the chart using data callouts.  To the right of the chart, you'll also notice a summary of the highest month of sales and the lowest month of sales with their corresponding values.

Finally, the dashboard will allow you to select any given month and get the details on the total sales for that month and which customer had the most and least sales for that month.

Here are the only fields you'll need for the dashboard to work:

* Customer
* Item Category
* Item
* Item Description
* Qty
* Unit Price
* Total Value Sold

The EOM Date column will automatically be calculated when you dump your data into the table.

Disclaimer:

This dashboard is intended strictly as a reference tool. I am and will not be held responsible for any potential errors when using this dashboard or any decisions that are being made as a result of using this product. This product is also mostly for the use of helping users dissect and learn how to use and create Excel dashboards. Please use this dashboard at your discretion and make sure to clearly review your numbers on the dashboard to ensure its accuracy.