Hi all,
I have a fairly large dataset that is broken down as minute-by-minute data.
I am plotting various charts from the PivotTable data, generally using averages.
I have "Time" in the row field on my PivotTable, but when I plot a chart it gives me some strange time values along the X axis, see screenshot below.
So I have a couple of questions.
1) As my data contains values from every minute of the day, how can I format the X axis to something more logical, such as every 15 minutes, starting at 00:00, then 00:15, 00:30, 00:45, etc.
2) Secondly following on from that, how can I make some vertical gridlines appear at set intervals, say on the hour, so every xx:00 has a vertical gridline?
As always, grateful for any help
Thanks
I have a fairly large dataset that is broken down as minute-by-minute data.
I am plotting various charts from the PivotTable data, generally using averages.
I have "Time" in the row field on my PivotTable, but when I plot a chart it gives me some strange time values along the X axis, see screenshot below.
So I have a couple of questions.
1) As my data contains values from every minute of the day, how can I format the X axis to something more logical, such as every 15 minutes, starting at 00:00, then 00:15, 00:30, 00:45, etc.
2) Secondly following on from that, how can I make some vertical gridlines appear at set intervals, say on the hour, so every xx:00 has a vertical gridline?
As always, grateful for any help

Thanks
