Hi,
Hopefully a quick question. One of my divisions has come back and "demanded" that I correct their graph as it is showing a negative value on the Y Axis and the Divisional Revenue can never be negative!!
I know why it has happened (and the attached screen clipping shows it). There is a week over the CHristmas closure where we had two "part weeks" either side of the company closure, and as the graph is a smooth line chart the smoothing has taken the "curve" below £0 and the axis has auto-adjusted to show this, but it has auto-adjusted to a minimum value of -£20,000 and the division manager is not happy :-)
How can I pin the Y-Axis to a minimum value of £0 and have the dip under this caused by the smoothing just be cropped ?
I am guessing this will be some kind of customisation setting on the Y-Axis configurator ...
Thanks,
Steve