- Excel has a feature called WordArt,…and typically it's used not on charts,…but in worksheets, also available in…Microsoft Word and in PowerPoint.…We can use it in charts in a more limited way…and possibly for main titles.…I want this to have a little bit more flair,…it's selected, I'll go to the Format tab in the ribbon,…and we see WordArt Styles.…Now, the drop arrow here gives us lots of choices,…and once again we see this issue…where the drop arrow activates options…and it hides the actual chart we're working with,…so I'll drag this down to here,…also that chart off to the left I'll move…into the background too.…
So, we want to make changes to this title.…Here are some options.…If we pick one of the options that can encompass some space…like these letters here, choose one of those possibly,…I'll use this one, we can see what's happening.…And to make this more prominent,…I'm going to use a larger font.…The best way to do this is to go to the Home tab,…right now it's 18 point font,…I'll use a much larger entry, how about 32 point,…
Author
Updated
3/1/2016Released
2/16/2016The training wraps up with lesson on changing data sources for charts and printing and sharing charts.
- Identifying chart elements
- Selecting the right chart type
- Creating basic charts
- Creating sparklines
- Styling charts
- Moving and resizing charts
- Modifying axes
- Adding labels and gridlines
- Analyzing data with trendlines
- Inserting pictures, shapes, and text boxes
- Customizing column, bar, line, and pie charts
- Creating Gantt charts and other specialized Excel charts
- Changing data sources
- Printing and sharing charts
Skill Level Intermediate
Duration
Views
Q: This course was updated on 03/01/2016. What changed?
A: We added one tutorial about the new Funnel chart type in Excel 2016.
Related Courses
-
Introduction
-
Welcome57s
-
-
1. Review the Basic Elements of an Excel Chart
-
Select the right chart type3m 33s
-
Understand chart sub-types2m 39s
-
2. Create Basic Charts
-
3. Style Your Charts with the Design Tab
-
Add a chart element3m 58s
-
Change a chart's type2m 22s
-
-
4. Fine-Tune Your Chart Elements
-
Modifying axes7m 48s
-
Linking titles to content3m 55s
-
Adding a Data Table4m 6s
-
Adding error bars4m 7s
-
Working with gridlines3m 55s
-
-
5. Format Tab: Insert Pictures, Shapes, and Text Boxes
-
Add shapes and arrows3m 33s
-
Add shape effects4m 10s
-
Apply WordArt styles2m 56s
-
Work with chart text2m 13s
-
6. Adjusting Specific Chart Types
-
Customize line charts5m 39s
-
Customize pie charts7m 50s
-
7. Other Specialized Excel Charts
-
Create combination charts4m 47s
-
Create Gantt charts7m 55s
-
-
8. New Chart Types in Excel 2016
-
TreeMap chart5m 20s
-
Sunburst chart3m 16s
-
Waterfall chart5m 13s
-
Histogram chart4m 14s
-
Pareto chart4m 22s
-
Box and Whisker chart4m 1s
-
Funnel chart3m 5s
-
9. Change a Chart's Data Source
-
Add new data using a table6m 38s
-
10. Print and Share Charts
-
Print your charts6m 15s
-
-
Conclusion
-
Next steps42s
-
- 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: Apply WordArt styles