Create Your First Chart in 10 Minutes (Using Excel)

This guide walks you through creating your first chart in Quality Window using a sample Excel file.

No setup required. Just open Excel and preview.

What You Need

  1. Quality Window installed
  2. Access to the sample Excel files:
    1. C:\Busitech\QW6\Sample Applications\Sample Excel Files

Use: Quality Sampling Example.xlsx

Step 1 – Open Excel First

Open Quality Sampling Example.xlsx in Excel

Close any other Excel windows, or make sure this file is the active Excel window

Quality Window reads from the active Excel instance.

NOTE: If Excel is not open first, no data will load.

Step 2 – Open Quality Window and Import

Open Quality Window Admin

Click Excel to QW Importer

The importer will automatically load data from the active Excel file.

QW Admin Excel to QW Importer Icon

Step 3 – Confirm Data is Loaded

You should see your Excel data in the importer grid

If no data appears:

Click Connect to Excel

Example of the Connect to Excel button
Example of the Connect to Excel button



Make sure your Excel file is the active window
Try again

Excel To QW Importer showing loaded data
Excel To QW Importer with loaded data

Step 4 – Preview in Quality Window

Click Preview in Quality Window

This will open Quality Window Workstation and display your data in the logsheet.

Example of Preview in Quality Window button
Example of Preview in Quality Window button

What You’re Looking At

Your data is now active inside Quality Window.

This is not a static spreadsheet.

Values are automatically evaluated and highlighted:

  • Green = Target Range
  • Yellow = Warning range
  • Red = control limit violation
  • White = outside specification
Example QW Logsheet with colored values

Step 5 – View Your First Chart

At the bottom of the screen, click Control

A control chart will appear automatically using your data.

Control tab location

What to Look For

The chart shows how your process behaves over time

Points outside limits are automatically highlighted

In the bottom right:

QW StatSense displays calculated statistics

In the bottom Left:

The Histogram shows the distribution of the data

Example Control Chart Screen with Stat Sense and Histogram
Example Control Chart Screen with Stat Sense and Histogram

You’re Done

You’ve created your first chart in Quality Window.

Your data is now:

  • Evaluated automatically
  • Visualized with control charts
  • Summarized with key statistics

What to Do Next

Use Your Own Data

You’ve seen how it works with sample data. Now try your own Excel file using the same process.

Most users are able to get their own data charting in minutes.

Explore More Examples

See how Quality Window is used across different scenarios.

Browse the sample applications included with your installation to understand what’s possible.

Need Help Getting Your Data Working?

If your data is more complex, we can help you get your first application set up quickly.

We’ll respond quickly and can set up a short call to help you get your data working.

Evaluating for Production Use?

If you’re considering Quality Window for real-world deployment, we can walk through your environment, licensing, and rollout options.

Notes

  • Quality Window reads from the active Excel instance
  • If the wrong file loads, activate the correct Excel window and click Connect to Excel
  • If Excel cannot be detected, a prompt will appear
  • Click Yes to open a new Excel instance
  • Re-open your file in that window
Example Connection Helper Message
Example Connection Helper Message
  • Some analysis views require specification limits and additional setup

Unlock powerful SPC insights with Quality Window

Quality Window gives manufacturing teams the tools they need for real-time SPC monitoring, automated CoA generation and fast root-cause analysis. Start your free trial and see how it can improve your process quality.

Translate »