Excel 2007 Pivot Chart

[Spaniel]

Hi all,

I'm using a pivot table to create a graph of trending. To simplify the issue as much as possible:

I have 2 columns; one is login time, one is login count

If for example 10 people login at 13:00, 3 at 15:00, I'd like the graph to start at 00:00 and run to 23:00, showing when people logged in.
​

The issue is that if there are no logins between, say 00:00-05:00, the graph will just start at 06:00.
​

Is there a way to set the default scale, like you'd normally do with a non pivot graph?

Excel 2007

Thanks in advance,

 

[jae113]

I don't think it is possible if you are using a Pivot Data field to create that axis.

But if not, you can try PivotChart Tool - Layout - Axes