Solved

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

Posted on 2015-02-10
10
140 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-SSA
  • 3
  • 3
  • 3
  • +1
10 Comments
 
LVL 45

Expert Comment

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

Author Comment

by:Ed-SSA
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

Expert Comment

by:teylyn
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
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40601848
0
 
LVL 45

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 40601861
Right-click on the axis and then choose "Select Data".
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 50

Expert Comment

by:teylyn
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
 

Author Comment

by:Ed-SSA
ID: 40601903
Martin -

Thanks - that got it !!
0
 
LVL 45

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

Expert Comment

by:teylyn
ID: 40601910
Ed, what was wrong with my answer?
0
 

Author Comment

by:Ed-SSA
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

759 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now