Excel Pivot Chart 'fixed' horizontal axis

Question

I have got a horizontal axis that holds numbers (roughly 7,5 through 18 at 0,5 intervals) based on the set filters.

I would like it to always show the 7,5 though 18 on the horizontal axis, even if the filtered only is applicable 10 to 12,5 for example.

Thing is, the axis options do not show bounds to set as I have found to appear in other solutions:

I've double checked to make sure my axis data is formated as numbers:

In case of possible relevancy, the formula used to calculate the day time indicator is

=mround((mod(GDQ[Timestamp];1)*24);0,5)

Is there a way to have the horizontal axis always show start through end plotting the filtered data always on the same timeframe?

Answer 1

I had exactly the same issue, and solved it on the pivot table side. Go to the field setting (in your case for the day/time indicator, your x-axis), then to the tab "Layout & Print", and activate "Show items with no data".

Now every category will always show up in the pivot table, even with no data after you do some filtering with your slicer, and the layout of the graph will remain constant (axis limits).

Answer 2

I had the same question and was saved by the above answer!

Just to expand on the answer above, after ticking the "show items with no data" box in the field settings, if you also go into the pivot chart options and change "for empty cells show:" to '0', it will connect the empty data points at zero on the y axis which makes for a much nicer look.