Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar chart and I want the X axis to remain the same size even when the user selects part of the chart.
In the Axes tab of chart properties:
Under Dimension Axis (bottom half)
Select "Continous" (check box)
and then enter Scale values: Static Min, Static Max and if needed Static Step.
Hi,
Can you explain the requirements in detail.
are you expecting a scroll bar in the bar chart to always show limited number of values in X axis.
Thanks.
For an X axis ( the dimension), the chart has a series of dates (MMM-YYYY). When nothing is selected, the X axis stretches from Febuary 2010 to Feb 2016 (see image 1). If I select a section of the data that only takes place between May 2012 and Nov 2013, the bar chart will resize the X axis so that it starts at May 2012 and ends at Nov 2013 (see image 2). I don't want this to happen.
Instead, I want the bar chart's X axis to remain at Feb 2010 to Feb 2016 when the data is selected, sot that it gives a sense of the timeframe that the data happened within.
Try setting static limits to the AXES in the Axes tab of chart properties
In the Axes tab of chart properties:
Under Dimension Axis (bottom half)
Select "Continous" (check box)
and then enter Scale values: Static Min, Static Max and if needed Static Step.
Hi Cael,
in Your Expression use
{<MonthYearField=>}
like
Sum({<MonthYearField=>} Value)
Regards,
Antonio