Material Price Tracking

I know this may seem trivial and I'm sure it is, but I'm playing a video game and I'm trying to track the price for materials on the server's trading post. I want to find the best day(s) and time(s) to sell (mostly) and buy (maybe) certain materials. I already have a sheet that I enter the Material Name, Cost, Date and Time. What I need is a way to visually represent that information. Any ideas using Excel?

This could be achieved fairly easily with charts plotting against time of the day, day of the week and day of the month, using PivotTables and PivotCharts.