Chart Axis labelling - selecting which point the numbering starts

bark01

Board Regular
Joined
Sep 6, 2006
Messages
116
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?
 
Last edited:

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,080
Office Version
365
Platform
Windows
Which chart type? Easy to do with an xy scatter. Right click axis, click format axis and change settings as appropriate.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,685
Messages
5,470,132
Members
406,681
Latest member
sachinmasurkar

This Week's Hot Topics

Top