Excel Charting/ Graphing course
Excel Charting/ Graphing course
An online Excel charting/ graphing course covering how to understand charts and how to get them to do what you want.
Includes how to create secondary axis, adding commentary directly to the labels and axis, dealing with dates in the horizontal axis and much more.
- Time Req – 8 hrs
- Skill Score >3.5
- FAQ
- All Online Courses
- Live Course Options
- Ask a Question
Modules
Chart Setup
Lessons
- Excel Charting introduction
- Create a chart
- Align chart to the grid lines
- Chart doesn’t look right? First thing to try
- Customise the chart title, area, legend and more
- Vertical Axis- force the scale, reverse the order, labels and more
- Horizontal Axis- dates vs text, reverse order, show all labels
- Series- overlapping, big and small series, gaps
- Chart Examples- Look and Feel
- Add more series to the chart- 3 ways
- Show big and small numbers on the same chart (and be able to see them)
- Show months, quarters AND years on the chart axis
- Chart Examples- Series and Axis
Chart Types
Lessons
Chart Tips and Tricks
Lessons
Advanced Charting
Lessons
- Combine a column with a line chart (or other combinations)
- Stop charts stretching when the column width changes
- Customise the series marker to your own image
- Add linked commentary directly to the chart
- Add commentary to the axis
- Add commentary to labels and call outs
- Add commentary to labels for older versions of Excel
- Hiding a series with NA()
- Chart Examples 1- Conditional bar charts, Chart builder
- Chart Examples 2- Combo Charts
- Chart Examples 3- Add Commentary
- Create a waterfall chart (pre Excel 2016)
- Create a waterfall chart (Excel 2016 and higher)
- Understand and use XY charts e.g. Risk Register
- Chart Examples 4- Waterfall Chart and Risk Register
- Change the default colour scheme in charts
- Create a chart template for re-use
- Add a trendline to a chart
- Benefit of using a table for chart data
- Link Excel chart to PowerPoint or Word
