kazmdav

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

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

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

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

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

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

I cannot see that in your chart.

Can you explain?

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?

ASKER

Hi,

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

Influenz, thank you, that fixed my problem.

Cheers,

kazmdav

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

Influenz, thank you, that fixed my problem.

Cheers,

kazmdav

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