Chart Axis labelling - selecting which point the numbering starts

bark01

Board Regular
Joined
Sep 6, 2006
Messages
135
Office Version
  1. 365
Platform
  1. Windows
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:

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Which chart type? Easy to do with an xy scatter. Right click axis, click format axis and change settings as appropriate.
 
Upvote 0

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top