Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2015-02-10
10
Medium Priority
?
156 Views
Last Modified: 2016-02-11
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
Comment
Question by:Ed Covney
  • 3
  • 3
  • 3
  • +1
10 Comments
 
LVL 50

Expert Comment

by:Martin Liss
ID: 40601772
Right click on the chart and choose "format Axis".
0
 
LVL 3

Author Comment

by:Ed Covney
ID: 40601827
Martin -

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

Thanks

Format-Axis.jpg
0
 
LVL 50
ID: 40601847
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
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
LVL 27

Expert Comment

by:ProfessorJimJam
ID: 40601848
0
 
LVL 50

Accepted Solution

by:
Martin Liss earned 2000 total points
ID: 40601861
Right-click on the axis and then choose "Select Data".
0
 
LVL 50
ID: 40601902
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
 
LVL 3

Author Comment

by:Ed Covney
ID: 40601903
Martin -

Thanks - that got it !!
0
 
LVL 50

Expert Comment

by:Martin Liss
ID: 40601907
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
 
LVL 50
ID: 40601910
Ed, what was wrong with my answer?
0
 
LVL 3

Author Comment

by:Ed Covney
ID: 40602093
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question