Join Dennis Taylor for an in-depth discussion in this video Adding error bars, part of Excel 2016: Charts in Depth.
- View Offline
- Exercise Files
- If you work with line charts and column charts, you might…want to use a feature called Error Bars.…If we click the chart to the right of the data here and go…to the Design tab, we can use the Add Chart Element button…off to the left.…You'll see a choice called Error Bars.…And as I slide over the choice here, if you work with…statistics, you'll be familiar with the term Standard Error.…You see in the chart, what's being shown, a vertical bar…above and below the points.…Slide over percentage looks almost the same.…
Standard deviation quite a bit different.…How about more Error Bar options.…And by the way, you can get to these same choices if you…were to click the plus button just to the right of the chart…over here.…We also see Error Bars there.…I'm not getting the visual in quite the same way…of the preview.…But we do have ultimately the same options.…And here too, we could get to more options.…So, in either case, choosing more options, we activate this…dialog box here.…And sometimes what you want to do is experiment with this.…
The 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
1. Review the Basic Elements of an Excel Chart
2. Create Basic Charts
3. Style Your Charts with the Design Tab
4. Fine-Tune Your Chart Elements
5. Format Tab: Insert Pictures, Shapes, and Text Boxes
6. Adjusting Specific Chart Types
7. Other Specialized Excel Charts
8. New Chart Types in Excel 2016
9. Change a Chart's Data Source
Add new data using a table6m 38s
10. Print and Share Charts
Print your charts6m 15s
- 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.Cancel
Take 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.