Excel for Mac 2016: Charts in Depth
Overview
Learn to create different kinds of Excel charts, from column, bar, and line charts to doughnut and scatter charts, with Excel for Mac 2016.
Charts allow you to communicate information visually, with greater impact than tables or raw data. They also happen to be one of the most powerful and easy-to-use features in Microsoft Excel for Mac. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to doughnuts and scatter charts, and decide which type works best for your data. Learn how to fine-tune your chart's colors and style; add titles, labels, and legends; insert shapes and pictures; and pull data from multiple sources. Along the way, Dennis offers shortcuts and tips for being more productive and efficient.
Charts allow you to communicate information visually, with greater impact than tables or raw data. They also happen to be one of the most powerful and easy-to-use features in Microsoft Excel for Mac. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to doughnuts and scatter charts, and decide which type works best for your data. Learn how to fine-tune your chart's colors and style; add titles, labels, and legends; insert shapes and pictures; and pull data from multiple sources. Along the way, Dennis offers shortcuts and tips for being more productive and efficient.
Syllabus
Introduction
- Welcome
- Using the exercise files
- Select data to display as a chart
- Create charts with a keystroke or with ribbon icons
- Use the Recommended Charts options
- Identify chart elements
- Select the right chart type
- Use chart terminology
- Use Charts Ribbon tab
- Add titles, labels, gridlines and other chart elements
- Choose a chart layout from the Quick Layout button
- Select chart colors and chart styles
- Use the Switch Row/Column button for a different view of the data
- Change a chart's data source
- Adjust chart settings to manage empty and hidden cells
- Change a chart's type and save it as a template
- Change the location of a chart
- Modify axes
- Add, edit, and remove chart titles and axis titles
- Link titles to content
- Add and edit data labels
- Add a data table
- Add error bars
- Work with gridlines
- Add, edit, and remove legends
- Add drop lines, up/down bars, and high-low lines
- Analyze existing and projected data with trendlines
- Add color backgrounds to chart elements
- Explore chart element formatting: Fill, outline, and effects
- Alter chart text styles: Fill, line, and effects
- Add shapes, text boxes, and arrows; add text and apply styles
- Use pictures as chart elements
- Use right-click and double-click to quickly adjust formats
- Column and bar charts
- Line charts and area charts
- Pie charts and doughnut charts
- Scatter charts and bubble charts
- Stock charts and radar charts
- Add or delete data in a chart
- Create charts from multiple data sources
- Update charts automatically with a table as source data
- Create combination charts
- Create Gantt charts
- Create frequency charts
- Use Developer tab controls to create dynamic charts
- Produce dynamic charts by using filters
- 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
- Use Conditional Formatting options to create in-cell charts
- Move and resize a chart within a worksheet
- Convert a chart to a graphic
- Goodbye
Taught by
Dennis Taylor
Related Courses
Reviews
0.0 rating, based on 0 reviews
Never Stop Learning!
