Charts are the core of dashboards and reports and often require user choices and inputs. In this eye-opening hour, you’ll discover different techniques to make charts dynamic, including Worksheet layout, Tables, Named ranges, Formulas. The best thing? All techniques covered in the session work in Excel online and Excel for mobile.
Session Resources:
- Collab365 – dynamic charts for browser and mobile.pptx
- Dynamic Excel Charts for Browser and Mobile_Final.xlsx
You will learn:
- how to create dynamic charts with Excel Tables and slicers
- how to create charts for rolling periods
- how to plot data in a time window
- how to highlight data in a busy chart
- how to highlight data that meets a condition
- how to control Y axis scales in side by side charts
- how to let the user choose different data labels
