I’m working with line charts, and labels on the horizontal axis. Is there any way to get them midway between tick marks instead of on the tick marks? As an example, the work sheet has 12 entries, with a tick mark and vertical grid line every 4 entries. I want the display on the horizontal axis to start with the 3rd entry, not the first, and then then show every 4th entry after that.
On the attached Excel document, the labels are at 0, 4, 8, and 12. Is there any way to make them be at 2, 6, 10, and 14?

Attached Files

Label Example.xlsx (11.5 KB, 11 views)

You can use an additional column with the labels you want to see and assign that to the category values.

This doesn't work. In the attached file, (label example2.xlsx) I added column C, and put the desired display numbers there, and selected that column for the horizontal category axis labels. But they don't show up on the plot. What am I doing wrong?

Attached Files

Label Example2.xlsx (11.4 KB, 9 views)

Format the X axis and put the interval between labels back to Automatic.

AHA! That did it! Thank you for solving a problem that has had some of us stumped for a long time!

You're welcome.