Excel Charts Best Practice
1-Day Workshop
In our seminar, you'll learn how to effectively use Tornado charts to visually compare data series. You'll also discover how Competitive charts can be used to graphically represent your company's position. Furthermore, we will show you how to present widely varying numerical values using line and bar charts with two axes. This enables a clear presentation of different data and trends for your management. With this knowledge, you will be able to create meaningful reports and present complex data in a simple and understandable way. Our hands-on tips and practical examples will help you unleash the full potential of your data visualization.
Workshop Content
Basics of Working with Charts:
- Overview of different chart types
- Creating and editing charts
- Getting to know the elements of a chart
- Saving charts as templates
Column and Bar Charts:
- Column chart with an image in the background
- Columns with differently colored negative values
- Waterfall chart for cost control
- Gantt chart for project monitoring
- Bar chart with images in the bars
- Tornado chart for comparing data
- Line / bar chart with two axes to compare different numerical values
Line and Area Charts:
- Line chart with AutoShapes
- Competitive comparison with a line chart
- Line and area chart with arrows
Bubble Charts:
- Creating traffic lights from a bubble chart
Preparing Data for Charts:
- Filtering data based on specific criteria
- Further processing filtered data
- Creating, copying, and processing partial results
Who Should Attend This Workshop?
This workshop is ideal for users who want to professionally analyze data in Excel and present numerical data in an appealing and convincing way.