• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 167
  • Last Modified:

Excel 2010 How can I change a chart's x-axis labeling?

I select a column of data (33 items) and create a simple 2D column chart from it. The x-axis number is 1..33 but I want it to be 0..32. If I right-click the x-axis labels I get a "Format Axis" menu but no ability to start the label at zero.

TIA,

Ed
0
Ed Covney
Asked:
Ed Covney
  • 3
  • 3
  • 3
  • +1
1 Solution
 
Martin LissOlder than dirtCommented:
Right click on the chart and choose "format Axis".
0
 
Ed CovneyRetiredAuthor Commented:
Martin -

Been there a dozen times - where/how do I change the starting value from 1 to 0?

Thanks

Format-Axis.jpg
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

if you don't specify the X axis labels from a cell range, Excel will number the categories, starting at 1, like in the top chart of the screenshot.  If you want to have labels that start with 0, then enter the numbers into the sheet and select that range as the X axis labels.

chart
cheers, teylyn
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
ProfessorJimJamCommented:
0
 
Martin LissOlder than dirtCommented:
Right-click on the axis and then choose "Select Data".
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
ProfessorJimJam, this is the second post within a few minutes where you post a blind link to an add-in, without providing any further information. In both cases the tool will not do what the asker is after. Please don't just post a link. Explain how to use the tool.
0
 
Ed CovneyRetiredAuthor Commented:
Martin -

Thanks - that got it !!
0
 
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Ed, what was wrong with my answer?
0
 
Ed CovneyRetiredAuthor Commented:
Teylyn,

Maybe nothing was wrong. I was never able to find the "Axis Labels" form you provided. I've only been playing Excel / VBA for about 6 weeks so without details for getting from pt A to pt B, I'm kind of lost.

Anyway, I tried what you suggested and I couldn't get it to work, Martin's answer only took me 2 or 3 tries to find and effect the needed change.

I do very much appreciate your efforts. I'll talk with you more of the y-axis side!

- Ed
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 3
  • 3
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now