Dashboard

[gleemonex69]

Good afternoon, Excel gods. I am in charge of gathering price changes of restaurant items from our distributor. Our Distributor sends me weekly and bi-weekly reports on only the items that have changed prices. In total, I have a little under 700 total items. I can't seem to figure out how to organize my data and how to create dashboards from that data. Any assistance would be greatly appreciated.

 

[Steve_]

Good afternoon, Excel gods. I am in charge of gathering price changes of restaurant items from our distributor. Our Distributor sends me weekly and bi-weekly reports on only the items that have changed prices. In total, I have a little under 700 total items. I can't seem to figure out how to organize my data and how to create dashboards from that data. Any assistance would be greatly appreciated.

I can surely promise you that you are going to need to provide a lot more information to get anywhere. Examples of the data you have. An explanation of what you want to do with that data. A description/example of how you want your output (in this case 'dashboard') to look.

We are certainly happy to help. But please provide as much info as you can without compromising the privacy/security of your data.

 

[gleemonex69]

So far, I have arranged my data like this:
https://imgur.com/2Sc3L4j

Item #, Cust Item # (not needed), Pack, Size, U of M, Item Label, Item description are all column headers
The date of the price change are also column headers, but I put prices in those columns. Difference (difference between this week and last week prices) and a day of week column that shows a red arrow for prices going up and green arrow for prices going down.

I intend to use this to track all prices changes. There aren't many per week with at most about fifteen price changes. I want to input price changes and I would like to see how the items that constantly change prices trend, either positive or negative. What the accounting department does with this information is beyond my paygrade. At the simplest, just a line graph showing how items changed prices.

 

[Michael M]

So you want 15 line graphs approximately ??
I'm guessing you have about a 1000 line items
If that's the case, have you considered copying all changed price data to a new sheet then graphing those line items ?
This could be done via VBA and the sheet could be cleared each time the code is run.....and the graph could be on a seperate sheet ?

 

[gleemonex69]

So you want 15 line graphs approximately ??
I'm guessing you have about a 1000 line items
If that's the case, have you considered copying all changed price data to a new sheet then graphing those line items ?
This could be done via VBA and the sheet could be cleared each time the code is run.....and the graph could be on a seperate sheet ?

That would suffice. I am not versed in VBA and would have no idea how to do it. Also, do you think I have my data arranged properly?