Multi Vari Chart in Excel

Multivari charts evaluate process variability within & between categories.

multivari chart in excel

How to Create a Multi Vari Chart Using QI Macros add-in for Excel

  1. First select your data. Multivari data can have one or more columns of words or numbers. The last column contains the values to be grouped and charted. Here is an example.

    multi vari data example
  2. Then click on QI Macros menu and find the Multi Vari chart under Box, Dot and Scatter Plots.

    multi vari chart on Excels menu
  3. QI Macros will perform all of the calculations and draw the multivari chart for you. This Multivari Chart shows the overall customer satisfaction by customer size and market segment.

    multi vari chart example in excel

How to Read a Multi Vari Chart

At first glance, multi vari charts can be overwhelming. Here is a quick overview of each element.

Elements of a Multi-Vari Chart

  1. Data for each category like "Large Consumer 1," is represented by a vertical line with horizontal cross bars. Each cross bar is a data point and a line is drawn from the highest to the lowest data point.
  2. Averages for each category are shown and compared to the others by drawing lines connecting the averages.
  3. The group average for the three categories is represented by the horizontal line. Compare these averages to the other groups.

To see the calculations for a QI Macros multi vari chart, just drag the chart over to the side to reveal the calculations behind it.

elements of a mult vari chart

Learn More...

Other Charts Created by QI Macros Add-in for Excel