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