Trend Charts template

Trends Scorecard

The 'Scorecard' template shown in this video has been replaced with the new 'Trend Charts Scorecard' template. (Trends.xlsx)

Everything is the same, except...

1. there are now more drag 'n drop trend charts,
2. macro buttons are in the Systems2win Ribbon menu

Topics in this Video

• Learning Objectives — 0:00
• Purposes of Trend Charts Scorecard — 0:15

  A well-designed system to organize, summarize, and archive so that you can better analyze your hard-won data.

• How to find your way around
  the sections of this template — 1:00
• Scorecard Data section — 2:40

  Where you do most of your daily or weekly data input.

• Source Data from a Check Sheet — 4:15

  Check Sheet template

• Period End Processing — 5:30

  Optional feature to summarize and archive your month-end data

  (to enable charts that show both current-period daily data and past-period monthly averages - on a single chart)

• Three optional ways to archive your data — 6:45
• Personalize to Analyze — 7:30
• Pre-programmed with popular charts — 10:00

  The new version has even more pre-programmed charts that you can simply drag into or out of the Print Area, and has new fields to simply enter the letters for the columns that you want to chart, and dropdown list to choose to chart the median, average, or your own user-defined calculation.

• Side-by-side Pareto Charts — 11:30

  To compare current period to any chosen prior periods.

• How to print different
  Print Areas — 12:00

  The new way is to use Systems2win menu >
  Print Area 1, 2, or 3

• Copy Chart button — 13:20

  Copies a picture of your selected chart to the clipboard, which can then be easily pasted into any other document.

Related Topics

• Trends Analysis template
• More Six Sigma Tools and videos
• Excel Charts
• How to personalize any Systems2win template

Foundational Learning

• Quick Start Initial Training   to use ANY Systems2win template
• Training & Support  home page
• Video Tips