On-Demand Webinar

Chart Speed Tips in Excel

  • Recorded May 21, 2019
  • 100 Minutes
  • Available now
4.9 / 5 4 attendee reviews
CE credits
  • 1.50 ATAAA (Aurora Administrative)
  • 1.50 ATATX (Aurora Accounting)
  • 1.50 ATAOP (Aurora Operations)

What You'll Learn

You’ll learn an array of techniques and time-saving tricks during this live presentation by Excel expert David Ringstrom, CPA. He discusses several invaluable Excel charting features, including the Recommended Charts feature, the Slicer feature, the Sparkline feature, the PivotChart feature, and others. David also explains how to avoid repetitive formatting, create self-updating chart titles, and liven up your charts with clip art. 
View Full Description

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast. 

Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

Topics Typically Covered:

•Incorporating comparison operators within SUMIF to sum numbers based on range criteria, such as greater than, less than, and so on.

•Creating rolling charts that automatically display data for the last five years, six months, or whatever time frame you choose.

•Creating pivot charts from lists of data in Excel.

•Building a Thermometer chart for use in fund drives and other goals as a means of exploring lesser-known chart options.

•Linking chart titles to worksheet cells as a step toward a self-updating chart title.

•Adding/removing chart features rapidly by way of the improved chart interface in Excel 2013 and later.

•Streamlining the process of resizing charts after you manually add data.

•Enlivening charts with clip art.

•Illustrating financial statements with the Waterfall chart in Excel 2016 and later.

Learning Objectives:

•Identify how to create self-expanding charts by way of Excel’s Table feature.

•Define how to save time by copying chart formatting between charts and using chart templates.

•Apply new charting features available in Excel 2013 and later.

Meet Your Speaker

David H. Ringstrom, CPA

David H. Ringstrom, CPA, is a nationally recognized instructor who leads dozens of Excel webinars each year. He is the author of Microsoft 365 Excel for Dummies and several other books. With over 30 years of consulting and teaching experience he empowers users to work more efficiently in...

View Full Bio of David H. Ringstrom, CPA

What Attendees Are Saying

  • “The time allotted to some participation questions was too short. ”

    Gwendolyn W.
See the survey ratings

4 attendees rated this webinar 4.9 out of 5 on average.

4.9 Overall Rating

Webinar Presentation

How many of the objectives of the event were met?
5.0
How useful was the information presented at this event?
4.8
Overall, how satisfied were you with this event?
4.8

Speaker Performance

Overall, how satisfied were you with this presenter?
5.0
How closely did the presenter follow the schedule?
4.8

CE Credits

These are the continuing education credits available to you for this webinar.

  • 1.50 ATAAA Aurora Administrative Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in administrative.
  • 1.50 ATATX Aurora Accounting Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in accounting.
  • 1.50 ATAOP Aurora Operations Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in operations.

Frequently Asked Questions

How do you create a self-expanding chart in Excel that automatically includes new data?
The key to creating a self-expanding chart in Excel is basing it on an Excel Table (formatted with Ctrl+T) rather than a fixed data range. When you create an Excel Table from your data, the table automatically expands to include new rows as you add them—and any chart based on that table updates automatically to include the new data without any manual intervention. To implement this: convert your source data range to a Table by clicking inside the data and pressing Ctrl+T, then insert a chart in the normal way (Insert > Chart). Any new rows added below the last row of data will be incorporated into the chart immediately after the chart is refreshed. This eliminates the common frustration of charts that become outdated as data grows, requiring manual range extension. For time-series data such as monthly revenue reports, this technique means that adding next month's data to the bottom of the table instantly updates all charts based on that data—with no chart editing required. Combining self-expanding charts with self-updating chart titles (linked to a cell containing a dynamic formula) creates a fully automated charting system that maintains itself as data evolves, significantly reducing the time spent on recurring report maintenance.
How do you copy chart formatting between charts in Excel to save time?
Reapplying the same formatting to multiple charts manually is one of the most time-consuming aspects of Excel reporting, but copying chart formatting between charts eliminates most of this repetitive work. The simplest method: click the chart that has the formatting you want to copy to select it, press Ctrl+C to copy it, then click a different chart that you want to reformat, then use Paste Special (Ctrl+Alt+V) and choose 'Formats' to apply only the formatting from the copied chart—not its data. This transfers color schemes, fonts, gridlines, axis settings, and other formatting elements to the target chart while leaving its data source unchanged. For even more control, save frequently used chart designs as chart templates: right-click a formatted chart and select 'Save as Template'—this saves the formatting as a .crtx file. Then, to apply that template to another chart, right-click the chart, select 'Change Chart Type,' navigate to the Templates folder, and select your saved template. This approach is particularly valuable in dashboard and reporting environments where consistency across many charts is a quality standard. Establishing chart templates for the three to five chart types your team uses most frequently—creating them once with approved formatting—and training all users to apply those templates rather than starting from scratch multiplies individual formatting savings across the full team.
What is the Sparkline feature in Excel and when should you use it?
Sparklines are miniature charts that fit within a single cell, providing a compact visual summary of a data trend without requiring a full-sized chart. They were introduced in Excel 2010 and are particularly useful in dashboards and reports where space is limited and a quick visual indicator is more valuable than a detailed standalone chart. To insert sparklines, select the cells where you want the sparklines to appear, go to Insert > Sparklines, and choose Line, Column, or Win/Loss. Then specify the data range containing the source values. Each selected cell displays its own mini-chart based on the corresponding data row. Sparklines are ideal for showing trends in tabular data—for example, a sales table with 12 months of data per product can have a sparkline column that shows each product's revenue trend at a glance, enabling readers to spot rising, declining, or volatile patterns without cross-referencing a separate chart. Win/Loss sparklines are particularly useful for showing positive/negative patterns, such as monthly profit or variance from budget. Formatting options allow you to mark high and low points, customize colors, and adjust axis scales. Sparklines update automatically when source data changes. Their primary limitation is small size—they communicate trend direction and relative magnitude but not precise values—making them a complement to data tables rather than a replacement for full-sized analytical charts.
How do you create a linked, self-updating chart title in Excel?
A self-updating chart title in Excel eliminates the need to manually edit chart titles when the underlying data changes—particularly valuable for recurring reports where dates, periods, or key metrics in titles change each cycle. The technique is straightforward: create a formula in a worksheet cell that generates the desired title text dynamically. For example, a cell formula might concatenate text with a date function: ='Sales Report – '&TEXT(MAX(A:A),"MMMM YYYY") to produce a title like 'Sales Report – March 2026' automatically based on the latest date in the data. Once the formula cell is ready, click on the chart title to select it (just the title text box, not the chart itself), then click in the Excel formula bar and type an equals sign followed by a click on the cell containing your formula. The chart title is now linked to that cell and will update automatically whenever the cell's value changes. This technique works for any chart text element that can be linked to a cell, including axis titles. For annual reporting cycles, a linked title that automatically displays the current fiscal year or period eliminates a small but consistent source of errors in report headers. Combined with self-expanding chart data ranges (using Excel Tables), linked titles create a largely self-maintaining chart that requires only new data entry—not manual formatting updates—to remain current.
What is the Waterfall chart in Excel and how is it used in financial reporting?
The Waterfall chart, introduced natively in Excel 2016, is specifically designed to visualize how an initial value is incrementally increased or decreased by a series of positive and negative values to reach a final total. It is one of the most powerful chart types for financial reporting because it visually decomposes a change—such as the movement from one period's revenue to another, or the components of a budget variance—in a way that immediately communicates both the direction and magnitude of each contributing factor. The classic financial use case is a profit bridge: starting with prior-year net income, the waterfall shows the impact of revenue growth, cost changes, and other factors as rising or falling bars, ending with current-year net income. The visual makes the primary drivers of change immediately obvious in a way that tables cannot. To create a Waterfall chart in Excel 2016 or later, select your data (categories and values), go to Insert > Insert Waterfall, Funnel, Stock, Surface, or Radar Chart > Waterfall. Values automatically display as rising (positive, typically shown in one color) or falling (negative, another color) bars connecting end-to-end. Total or subtotal bars—which show cumulative values rather than incremental changes—are set by right-clicking the bar and selecting 'Set as Total.' Formatting the total bars distinctly from incremental bars makes the structure clearer to readers unfamiliar with Waterfall charts.