Search our courses

Course Duration – 1 day

Course Subjects

Excel Charting Concepts

Understanding chart terminology
– Identifying chart elements (such as like plot area, chart area, gridlines, and legends)
– Selecting the right chart type
– Understanding the Ribbon and the Design, Layout, and Format tabs

Creating Basic Charts Quickly

– Selecting data to display as a chart
– Creating charts instantly with shortcuts
– Creating presentation-ready charts with just a few adjustments
– Creating graphic-in-cell charts with Sparklines

Fine-Tuning Charts with Design Tab Choices

– Switching rows and columns for a different view of the data
– Setting a default chart type and creating a template
– Dealing with empty and hidden cells
– Choosing a chart style from 48 colourful variations
– Changing the location of a chart
– Moving and resizing a chart

Layout Tab Options

Inserting Pictures, Shapes, and Text Boxes
– Using pictures as chart elements
– Adding shapes and arrows
– Adding floating text and text boxes
Adding Titles, Labels, and Legends
– Adding and editing chart titles
– Adding horizontal and vertical titles
– Linking titles to content
– Showing different scales
– Specifying the position of tick marks and axis labels
– Changing the numeric format on labels
– Adding, editing, and removing legends
– Adding and editing data labels
– Showing the source of a chart’s data

Using Axes and Gridlines
– Modifying axis scaling
– Working with gridlines
Using the Analysis Tools
– Analyzing existing and future data with trendlines
– Adding drop lines
– Adding high-low lines and up-down bars
– Adding error bars

Format Options

Adding Shapes and WordArt Styles
– Selecting shape fill and outline
– Adding shape effects
– Applying WordArt styles
Using Other Formatting Tools
– Formatting lines and borders
– Filling an area with a colour gradient
– Specifying line style and weight
– Working with chart text
– Changing the rotation of chart text

Adjusting Specific Chart Types

– Column, line and pie charts
– Area, stock, and XY charts
– Doughnut, bubble, and radar charts
– Creating a Waterfall chart

Changing a Chart’s Data Source

-Pasting new data into a chart
-Creating charts from multiple data sources
-Adding new data using a table

Printing and Sharing Charts

– Printing charts
– Copying and linking charts with Word and PowerPoint