We help IT Professionals succeed at work.

Excel 2010 - More detail on horizontal axis lines

kazmdav
kazmdav asked
on
290 Views
Last Modified: 2012-05-31
Hi,

I found excel 2003 intuitive & I used to know this. Although I'm not sure what 2010 is trying to be, it's just not agreeable to me. Without time to work it out myself, I need to know this quickly.

In Excel 2010; I need to know how to change my chart's horizontal axis to give more detail than the default axis is, please.

For example, attached file has horizontal axis in increments of 5 (from 0 to 20). I want increments in 1's, i.e. 1,2,3,4,5,6,7 etc.

That's it.
Assessment-results.pdf
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
Hello,

I'd like to help, but I can't do anything with a PDF where the pertinent parts of the chart are masked.

Please post a sample file with dummy data to illustrate your problem.

cheers, teylyn
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Hi Teylyn,

Sure, here's an example attached.

Do you do any quick basic online lessons in Excel 2010, by the way? The concept for chart creation has certainly seemed to have changed, compared to 2003 version.

Thank you.
question-example-for-Experts-Exc.xlsx
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
Hello,

the X axis in your sample does not have any relation to numeric data, it's all text values.

In your original question you say

For example, attached file has horizontal axis in increments of 5 (from 0 to 20). I want increments in 1's, i.e. 1,2,3,4,5,6,7 etc.

I cannot see that in your chart.

Can you explain?

Author

Commented:
Hi,

Teylyn, I apologise, I meant the vertical axis, the Y axis.

Influenz, thank you, that fixed my problem.

Cheers,
kazmdav
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.