Excel 365 in 30 Minutes – Charts (Advanced 9 of 11)

In this Bigger Brains course, you’ll learn how to move beyond basic charts and work with advanced charting features in Excel 365. You’ll explore how to customize charts by changing series order and value axes, create less common chart types like pictograph and radar charts, and design combo and dual-axis charts to display multiple data sets effectively. You’ll also see how to link chart label text directly to worksheet cells so your charts stay accurate and dynamic as data changes. 

You’ll learn how to analyze trends visually by applying, changing, and formatting trendlines. You’ll also learn how to create reusable chart templates and apply them to both new and existing charts for consistent formatting. Finally, you’ll see how to create PivotCharts, apply PivotChart filters, connect slicers to multiple charts, and prevent charts from resizing when worksheet changes, giving you greater control over both chart design and layout. 

Topics covered include: 

• Customizing a chart by changing series order 

• Customizing the value axis of a chart 

• Creating and modifying a radar chart 

• Creating a combo chart  

• Creating a dual-axis chart 

• Linking label text to a cell 

• Applying and formatting a trendline 

• Creating a chart template from an existing chart 

• Applying a chart template to new and existing charts 

• Creating a PivotChart 

• Using PivotChart filters 

• Linking a slicer to multiple charts 

• Preventing charts from resizing when columns or rows are modified 

Enjoy award winning HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and include captions and transcripts, downloadable handouts, and optional LinkedIn digital badges on course completion.