If you want to control the appearance of axes lines or gridlines, you can do…this in a number of different ways. And in some sense, this illustrates the fact…that I think a lot of us, myself included, become a little bewildered at times as…what's the best way to do things, because they're so many different ways to approach this.…In the chart on the left are some gridlines, and maybe we want to make some changes.…Now a lot of you know that in creating gridlines many times where you would…start would be to go to the Layout tab and choose Gridlines,…possibly apply them this way. And along the way in that process you might come to…More Primary Horizontal Gridline Options, makes some choices.…
We can control Line Color and Line Style, so there is certainly that approach.…When you created the chart you could have gone to the Design tab, chosen Chart…Layouts, and some of the options here have gridlines, some don't.…You could've start the gridline process that way. How about format?…We could go to Format, and if you have selected a gridline as I have here, we've got…
Author
Released
6/15/2011- Identifying the plot area, chart area, gridlines, legends, and more
- Selecting the right chart type
- Creating charts instantly with shortcuts
- Choosing a layout
- Dealing with empty and hidden cells
- Switching rows and columns for a different view of the data
- Moving and resizing a chart
- Inserting pictures and shapes
- Adding labels to a chart
- Analyzing existing and future data with trendlines
- Changing a chart's data source
- Printing charts
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2007: Pivot Tables for Data Analysis
with Curt Frye2h 45m Intermediate -
Excel 2007 Power Shortcuts
with Michael Ninness2h 4m Intermediate
-
Introduction
-
Welcome59s
-
-
1. Understanding Excel Chart Concepts
-
2. Creating Basic Charts Quickly
-
3. Fine-Tuning Charts with Design Tab Choices
-
Choosing a chart layout4m 33s
-
Moving and resizing a chart5m 14s
-
4. Layout Tab Options: Inserting Pictures, Shapes, and Text Boxes
-
Adding shapes and arrows3m 37s
-
5. Layout Tab Options: Adding Titles, Labels, and Legends
-
Linking titles to content2m 32s
-
6. Layout Tab Options: Using Axes and Gridlines
-
Modifying axis scaling3m 50s
-
Working with gridlines4m 23s
-
-
7. Layout Tab Options: Using the Analysis Tools
-
Adding drop lines3m 14s
-
Adding error bars3m 58s
-
8. Format Tab Options: Adding Shapes and WordArt Styles
-
Adding shape effects3m 19s
-
Applying WordArt styles2m 51s
-
9. Using Other Formatting Tools
-
Formatting lines and borders4m 24s
-
Working with chart text3m 40s
-
-
10. Adjusting Specific Chart Types
-
Using column and bar charts7m 24s
-
Using line charts5m 46s
-
Using pie charts8m 37s
-
-
11. Changing a Chart's Data Source
-
12. Printing and Sharing Charts
-
Printing charts6m 19s
-
-
Conclusion
-
Next steps19s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Specifying line style, color, and weight