Excel: Charts in Depth
Overview
Explore how to add visual appeal to your spreadsheets and workbooks with this in-depth course on the powerful charting features of Microsoft Excel.
Excel charts allow you to communicate information with much more impact than raw numbers and are surprisingly easy to generate. Instructor Dennis Taylor shows you how to create different kinds of Excel charts, from column, bar, line and pie to more recently introduced types like Treemap, Funnel, and Pareto. He explains what types of data work best with each so you can decide which type to choose for your specific information. Plus, learn how to fine-tune your chart's color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources.
Excel charts allow you to communicate information with much more impact than raw numbers and are surprisingly easy to generate. Instructor Dennis Taylor shows you how to create different kinds of Excel charts, from column, bar, line and pie to more recently introduced types like Treemap, Funnel, and Pareto. He explains what types of data work best with each so you can decide which type to choose for your specific information. Plus, learn how to fine-tune your chart's color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources.
Syllabus
Introduction
- Add power to your data with charts
- Create charts with shortcuts and standard techniques
- Overview of chart types
- Choose styles and layouts
- Change chart orientation
- Move and resize worksheet charts
- Add a chart element
- Change the location of source data
- Deal with empty and hidden cells
- Change the default chart type and create a template
- Modify axes
- Work with chart and axes titles
- Link titles to content
- Add and edit data labels
- Add a data table
- Work with gridlines
- Use legends
- Add error bars, lines, and up-down bars
- Analyze existing and future data with trendlines
- Use pictures as chart elements
- Work with shapes and arrows
- Add shape styles and effects
- Add floating text and text boxes
- Work with chart text
- Apply WordArt styles
- Column and bar charts
- Line and area charts
- Pie charts and doughnut charts
- Combination charts
- Stock charts
- Scatter charts
- Bubble charts
- Radar charts
- Gantt charts
- Overview of new chart types
- TreeMap charts
- Sunburst charts
- Histogram chart
- Box and whisker chart
- Pareto chart
- Waterfall and funnel charts
- Map charts based on geographic data
- Create charts from multiple data sources
- Use a table as source data for a chart
- Print charts
- Copy and link charts with Word and PowerPoint
- Create graphic-in-cell charts with sparklines
- Use symbols and the REPT function for in-cell charts
- Create in-cell bar charts with conditional formatting
- Next steps
Taught by
Dennis Taylor
Related Courses
Reviews
0.0 rating, based on 0 reviews
Never Stop Learning!
