Home

Pivot Chart - horizontal axis not showing options for bounds

Bart de Brouwer
Occasional Visitor

I have got a horizontal axis that can hold 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 lower axis, even if the filtered only is applicable 10 to 12,5 for example.

 

Thing is, the axis options does not show bounds to set:

 

QZgwBBu

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

 

JPs3ZHr

 

Is there something else I need to do to have this processed as a number by the chart so I can set my axis' bounds?

Related Conversations
my chart can not smooth the points
inadotb in Excel on
2 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Problem sorting Pivot Table according to date
MikkoS in Excel on
1 Replies
Feature Request: Add Delete option to Downloads
Eric Hebert in Discussions on
4 Replies