Hi all,

I'm producing a graph off a set of data and need to display the time of an event against the sum of event readings. This can be done using a pivot chart to some degree but as far as my knowledge goes it doesn’t have any way of plotting this against a scaled axis from time 0.

I've attached an example workbook where the only way I can establish how to do this is by copying and pasting the data from the refreshed pivot table then building a chart off it. Preferably I would like for this to be done automatically or have a macro that does this for me.

Any help would be greatly appreciated. Thanks in advance.

Linc

"example data.xlsx" example data.xlsx