Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately.
When tick marks--now these are the little marks that we see on various axes in charts. In this particular chart, on the horizontal axis at the bottom of the screen we see tick marks. I think many of us probably ignore these most of the time, but sometimes they obscure chart elements, or they're not prominent enough. You can choose from a large set of tick-mark placement choices from the Layout tab. So let's select this particular axis here, and if you're having trouble clicking on it--and sometimes is that happens with charts, they're a little bit tricky as to how you might actually select an item-- on the Layout tab, in the Current Selection group on the left-hand side remember there is a drop arrow here, Horizontal Axis if you haven't chosen it manually. Then choose that.
Then let's go right below it in and choose Format Selection. A lot of choices in this dialog box, but let's focus on Major tick mark type. Currently it's Cross, meaning the tick marks across the axis. Another choice is Inside. You see how the tick marks appear this way, and another choice of course Outside. We will see them below this. Now many times I think it doesn't make a lot of difference, but suppose we go back to Cross. Sometimes the way these line up or don't line up with points above them, you might want to consider making a different choice.
Position Axis, On tick marks, Between tick marks. Many times we don't care, but certainly one time when you might is if, for example, in this chart here you were to add drop lines. Now that's covered in another movie, but I just want to point out that sometimes in line charts and in area charts it makes sense to show under analysis Lines > Drop Lines. So I'll just throw this in right here. You would probably want those to line up with the tick marks. So in that situation going back to Format Data Series here if we simply clicked that Horizontal Axis again, these choices come back.
Then Position Axis at the bottom On tick marks. Click here and we see what's happening there. Now you also have tick marks on the vertical axis too. In the example here in this particular worksheet these don't really make a lot of choices, but we see tick marks over here as well, too. Here they are accompanied along with gridlines. So that's a different choice. So here the option doesn't really make any difference at all if you have gridlines. You see how the Inside Outside is having slight impact on the Inside, but not on Outside at all. In other words, we see them there and we see them with Cross.
Those two are identical. So anytime you're working with charts that have axes and the tick marks do become important to you related to other features that you might have in a chart, you do have options both for horizontal and vertical axes to control tick marks.
There are currently no FAQs about Excel 2007: Charts in Depth.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.