Chart areas, plot areas, columns, bars, and many other chart elements have…borders and you sometimes want to change them.…You can adjust the color, the thickness, and the type or style of border.…Let's start with the title here in this chart on the left side of the screen here.…By way of the Format tab in the Ribbon rather than filling in the shape, how…about a shape outline here of one of these colors?…Possibly one of these here. Pick one.…If you want to change the style you might also notice here under Shape Outline,…the Weight here or Dashes.…
Now, you can get to these in another way too and some people prefer this approach.…If we simply double-click the border of the title here, the Format Chart Title…dialog box appears and here's the Border Color. Again, we could have started…here as well too by the way, and possibly we're going to change the color or…the gradient line, a line that varies in its color. I doubt if most people would want that.…Let's go back here and choose Border Styles.…
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 2010: Pivot Tables
with Curt Frye3h 43m Intermediate -
Managing and Analyzing Data in Excel 2010
with Dennis Taylor1h 32m Intermediate
-
Introduction
-
Welcome1m
-
-
1. Understanding Excel Chart Concepts
-
2. Creating Basic Charts Quickly
-
3. Fine-Tuning Charts with Design Tab Choices
-
Choosing a chart layout3m 22s
-
4. Layout Tab Options: Inserting Pictures, Shapes, and Text Boxes
-
Adding shapes and arrows2m 58s
-
5. Layout Tab Options: Adding Titles, Labels, and Legends
-
Linking titles to content1m 52s
-
6. Layout Tab Options: Using Axes and Gridlines
-
Modifying axis scaling7m 55s
-
Working with gridlines4m 11s
-
-
7. Layout Tab Options: Using the Analysis Tools
-
Adding drop lines1m 11s
-
Adding error bars4m 34s
-
8. Format Tab Options: Adding Shapes and WordArt Styles
-
Adding shape effects5m 34s
-
Applying WordArt styles2m 1s
-
9. Using Other Formatting Tools
-
Formatting lines and borders3m 45s
-
Working with chart text2m 47s
-
-
10. Adjusting Specific Chart Types
-
Using column and bar charts9m 12s
-
Using line charts5m 25s
-
Using pie charts6m 30s
-
-
11. Changing a Chart's Data Source
-
12. Printing and Sharing Charts
-
Printing charts6m 41s
-
-
Conclusion
-
Next steps43s
-
- 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: Formatting lines and borders