Avatar of kazmdav
kazmdav
Flag for Australia asked on

Excel 2010 - More detail on horizontal axis lines

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
Microsoft Excel

Avatar of undefined
Last Comment
kazmdav

8/22/2022 - Mon
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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
ASKER CERTIFIED SOLUTION
Steve Dubyo

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
kazmdav

ASKER
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
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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?
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
kazmdav

ASKER
Hi,

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

Influenz, thank you, that fixed my problem.

Cheers,
kazmdav