I had a time coming up with a concise title... but hopefully this will explain it better.
I have a line chart with values on the vertical and yearly quarters along the horizontal. The yearly quarters are labelled 0.25, 0.5, 0.75, 1.0, 1.25... etc.
As there area lot of quarters I have the interval unit set to 4, so on the chart there are tick marks against each quarter, but only every 4th data point has a label ie. 0.25....1.25...2.25.... etc.
I want to neaten it up and set the axis labels so they start at 1 rather than 0.25 i.e 1..2...3...4..., But I still want the data to start at 0.25. i.e 3 unlabelled tick marks (0.25,0.5,0.75) and then the 4th one labelled (1.0)
My 2 options at the moment are to start the chart at 1.0 and miss off the 0.27-0.75 data or create a 0 value at the start that has no data.
Is there anyway to do this without either adding a blank data point or missing off the first 3?
I have a line chart with values on the vertical and yearly quarters along the horizontal. The yearly quarters are labelled 0.25, 0.5, 0.75, 1.0, 1.25... etc.
As there area lot of quarters I have the interval unit set to 4, so on the chart there are tick marks against each quarter, but only every 4th data point has a label ie. 0.25....1.25...2.25.... etc.
I want to neaten it up and set the axis labels so they start at 1 rather than 0.25 i.e 1..2...3...4..., But I still want the data to start at 0.25. i.e 3 unlabelled tick marks (0.25,0.5,0.75) and then the 4th one labelled (1.0)
My 2 options at the moment are to start the chart at 1.0 and miss off the 0.27-0.75 data or create a 0 value at the start that has no data.
Is there anyway to do this without either adding a blank data point or missing off the first 3?
Last edited: