Competitor Pricing Excel Dashboard
This is an Excel workbook. I have attached 4 images, sheet 1 shows the raw data table in which new data each week would be added. Sheet 2 shows the pivot table, which is a functional table in which months and years can be collapsed. Sheet 3 shows the pivot chart for viewing the data, this takes the data from the pivot table and makes a responsive chart based on the data in the pivot table. The "slicers" on the right of the chart allow certain years/months/dates to be selected (you can add more slicers if needed) so that you can view a chart with the past 6 months, for example, or today's prices (although you'll need two dates for it to show on a line graph. A bar chart could be added to another sheet for looking at individual dates if needed). Colours and design are easily changed if need be, this is an example with the styles given by Excel. I think the graphs would look nicer with real data anyway though.
