PROGRAM, DAY 2
9:00 a.m. Start
+ Summary of Day 1
+ Questions and Answers
9:15 a.m. Column charts (Part 4)
To support the message, highlights are used in the form of lines, arrows, ellipses, and colors, positioned dynamically in the chart.
+ Positioning lines, arrows, and ellipses from outside the chart
+ Rotating arrows and determining colors from outside the chart
+ Performing a data-driven color change in the chart
+ Automatically hiding labels of small values
10:45 a.m. Bar charts
Bar charts are probably the second most important chart type.
They require special attention because you cannot use all of the tricks for column charts in the same manner for bar charts. There are different approaches to creating chart elements, such data series, axes, labels of bar charts. The most important visualization variations are presented here.
+ Understanding the differences between bar and column charts
+ Combining bars with scatters
+ Inserting an x-axis as a point
+ Adding legends to bar charts
+ Synchronizing point axes with bar axes
+ Stacking several charts appropriately
1:30 p.m. Exercise
Participants work on their own on the main aspects of bar charts using a prepared exercise.
2:30 p.m. Report layout (Part 1)
The transition from a single chart to a report page is explained and implemented using a grid layout and the Excel camera.
+ Positioning the message, title, and footnotes precisely
+ Including comments in the charts depending on context
+ Using the Excel camera meaningfully
3:45 p.m. Report layout (Part 2)
For use in a presentation, the report page created in Excel is linked with PowerPoint and thus remains dynamically updatable. In this case, appropriate working methods help to avoid the typical problems that arise from linking. Afterwards, the separate chart templates are configured meaningfully and the finished report page is examined.
+ Linking with PowerPoint and Word correctly
+ Configuring chart templates
+ Dynamically updating a report
5:30 p.m. End of Day 2