Excel Charting Specialist

Create and Amend Charts

Format multiple areas of a Chart

Use a Combo Chart

Apply Conditional Formatting to a Chart

Create Dynamic Charts

Work with Custom Formatting

Create an Advanced Dynamic Chart

Creating Simple Charts

Using the Chart Design tab

Adding Chart Elements

Changing the type of Chart

Format Chart Area

Format Data Series

Format Data Point

Format Axis

Adding additional data to a Chart

Customising Chart types

Creating Clustered Column/line Charts

Using IF Statements

Highlighting Max/Min Data points in Charts

Using Series Overlap

Creating dynamic Target vs Actual Charts

Introducing the NA function

Hiding data used for Charts

Formatting Data Labels

Customising number formats

Using Trend Arrows to show changes

Editing Format Code

Pivot Chart rules

Creating a Pivot Chart

Working with your Pivot Chart

Combining all elements to create an Advanced Chart

Using Error Bars to create a line

Adding a scroll bar and linking with data