Speaker(s):  Wayne Winston 

Duration: 60 minutes

Track: Data Analytics and Visualization

Join this session to dig into cool and little known Excel charting tips that will help your charts and dashboards come alive. You’ll learn how to add bling to your column graphs, how to use List boxes to choose the series charted in a graph, and how to use Checkboxes to select the series that show in a chart. We’ll cover using the OFFSET function to control the data points that appear in a chart, and finish up with a demonstration on how to use GETPIVOTDATA and the Excel Table feature to efficiently pull data from a PivotTable into a chart that dynamically updates as new data is added.