Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Chapter 44

Advanced charting

Questions answered in this chapter:

• How can I track sales-force performance over time?

• How can I create a band chart to check whether inventory is within acceptable levels?

• How can I store a chart as a template?

• How can I use a thermometer chart to portray progress against a target?

• How can I create dynamic chart labels?

• How can I use check boxes to control which series are charted?

• How can I use a list box to choose the series to be charted?

• How do I create a Gantt chart?

• How do I create a chart based on sorted data?

• How can I add conditional colors to a chart?

• How can I use the GETPIVOTDATA function and Excel’s table feature to create dynamic dashboards?

• How can I insert a vertical line in a chart to separate ...