Dynamic Excel charts for browser and mobile

Ingeborg Hawighorst

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:

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
(Visited 152 times, 1 visits today)

2 Free Ebooks: How to govern Microsoft teams 

Download your 2 free Microsoft Teams governance Ebooks and learn the steps necessary to create a bullet-proof governance strategy.