Revelator80
Technical User
Hi,
I have produced a chart based on a Moving Annual Total with months along the X Axis. Obviously, the data is not useful for the 1st year as it has not accumulated the 12 months required so I want to exclude this first year from the chart.
Is there an easy way of doing this, when I try and filter the data, it just starts the whole count from the start of the second year so the problem still exists.
I can see it can be done on the Y Axis but can't see it on the X Axis.
Cheers
David
I have produced a chart based on a Moving Annual Total with months along the X Axis. Obviously, the data is not useful for the 1st year as it has not accumulated the 12 months required so I want to exclude this first year from the chart.
Is there an easy way of doing this, when I try and filter the data, it just starts the whole count from the start of the second year so the problem still exists.
I can see it can be done on the Y Axis but can't see it on the X Axis.
Cheers
David