Hi,
I want to display gas prices from one or multiple stations changing during the day and compare to other days. Gas prices are delivered as CSV with one entry per change - if there is no update for several hours there is no entry for it. To draw a correct XY lline chart I had to double the data to account for the steady price until the next update happens:
source2adjusted2chart.png
What I want to achieve is a pivot chart from the source data where I can select one or multiple stations (id), one or several hours, days, weeks, ... I could mock this chart by blowing up the source data and generate a price value for each point in time. To keep Excel in a usable state I only created 108 (=(24-6) * 6) points per day. An exact chart with 1080 (=(24-6)*60) points is desired. And not having to blow up the data is desired as well. The mock up looks like:
mockup.png
My achievements with lines for several days for one station in the XY chart as well as in the pivot chart can be found here:
gasdb.xlsx
Bookmarks