Hi
How can I get the Bin below to indicate at the tick marks instead at the middle of interval?
I enclosed sample file.
Thank you
Bin Frequency
20000 18
25000 38
30000 18
35000 4
40000 2
45000 0
Hi
How can I get the Bin below to indicate at the tick marks instead at the middle of interval?
I enclosed sample file.
Thank you
Bin Frequency
20000 18
25000 38
30000 18
35000 4
40000 2
45000 0
If I understand what you are asking for, you should be able to go into the "format axis" dialog for the horizontal axis (https://support.office.com/en-us/art...rs=en-US&ad=US ) and, at the bottom of the dialog, should be an option to "position axis" "on tick marks" or "between tick marks". Select the desired option, to get the axis labels to show up underneath or between tick marks.
If that does not do what you want, you might look at Jon Peltier's site. He has several tutorials for different axis tricks (usually using a column/scatter combination chart). http://peltiertech.com/Excel/Charts/axes.html
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks