Open Qstat Qstat Desktop
English

Bar Chart Maker

Compare sales by region, defects by type and other category data with bars. Choose from vertical, horizontal, grouped and stacked bar charts, show values on the bars, and aggregate by category.

1Data Table

Paste a table copied from Excel into a cell (Ctrl+V). Click a column header (A, B…) before pasting to use the first line as column names. Double-click a header to rename it, right-click to insert/delete rows and columns, and formulas such as =A1*2 work too.

2Bar Chart Options

Select value data columns (multiple allowed):

How to make a bar chart

  1. Copy the category column (region, product, etc.) together with the value columns.
  2. Paste into the data table (paste on a column header to use the first line as column names).
  3. Choose the chart type, category column and value columns, and an aggregation method if needed.
  4. Turn on 'Show values on bars', press Draw, then right-click the chart to save or copy it as an image.

Choosing a bar chart type

Vertical and horizontal bar charts compare one or more values per category. Horizontal bars work better when category names are long. A grouped bar chart puts several value columns side by side per category, and stacked bar charts show each category's total and its composition in one bar.

Aggregating by category

If the same category appears in several rows, choose mean, sum, count, max or min to combine them into one bar per category, in the order the categories first appear. With 'None' each row becomes its own bar.

How to read a bar chart

  • The automatic interpretation names the category with the highest value for each series.
  • Sort or compare carefully when bars are close - small differences may not be meaningful.
  • For composition, a stacked chart shows totals; for comparing individual parts, a grouped chart is clearer.

Frequently asked questions

Can I make a stacked bar chart?

Yes. Choose 'Stacked Vertical Bar Chart' or 'Stacked Horizontal Bar Chart'. Negative values are stacked separately below zero.

Can I show the value on each bar?

Yes. Turn on 'Show values on bars'. Stacked charts show the value in the middle of each segment.

What if a category appears in several rows?

Choose an aggregation method (mean, sum, count, max, min) to combine them into one bar per category.

Is my data sent to a server?

No. Everything is processed inside your browser and nothing is transmitted or stored.

Other chart tools

Line Chart MakerCompare changes and trends over time or order across several series.Scatter Plot MakerPlot the relationship between two variables with a trendline, equation and R².Box Plot MakerCompare medians, quartiles and outliers of several groups side by side.

Need process capability, control charts or DOE?

The Qstat desktop program offers about 250 analysis features: histograms and box plots plus process capability (Cp, Cpk), control charts, measurement system analysis (MSA), design of experiments (DOE), regression and machine learning.

Try Qstat free for 30 days