Charting for trend analysis using Excel (54498127) - Recorded webinar

Learn how to display your data in multiple chart forms and then add trend lines using in-built analysis to project how data might appear in the future.

This recorded webinar will focus on creating three very different charts.

Key topics:

• Charts to use, and charts not to use, to show trends
• A trending column chart with shapes are the primary series
• A bullet chart (essentially an attractive stacked column chart)
• A four segment line chart, each with its own series

• Create trends using the ‘Forecast’ formula to track future sales or spend projections
• Add data tables to your report and create in cell formula which appears as a chart
• Add shapes to your charts to highlight when targets are met (these move dynamically as the goal posts shift)
• Work through the detailed tasks accompanying the webinar to test your knowledge