ChartPaste

Free Combo Chart Maker — Bars and a Line in One Chart

A combo chart puts two different kinds of number on one picture: bars for the quantities, a line for the rate. It is the standard business layout — monthly sales as bars with the growth rate as a line on top — because a rate of 0.12 next to a total of 120,000 is invisible on a shared scale otherwise.

IN
MonthProduct AProduct B
OUT

Everything except the last column is a bar; the last column is drawn as a line — the usual way to put a rate or a target next to totals.

Not sure which chart fits? Pick by what you want to show.

Every thumbnail below is drawn from your data — click one to switch. A ★ marks a type that suits this data.

Compare values

Which one is bigger, and by how much?

Change over time

How has it moved, and where is it heading?

Parts of a whole

What is the total made of?

Relationships

Do these things move together?

Distribution

How are the values spread out?

How it works

  1. Paste your table: the first column is the category, the remaining columns are numbers.
  2. Every numeric column becomes a bar except the last, which becomes the line — so put the rate, percentage or target in the last column.
  3. If the line's numbers are more than ten times smaller than the bars, it moves to a second axis on the right automatically.
  4. Download a 2× PNG, or the .xlsx with a native combo chart that stays editable.

Frequently asked questions

Which column becomes the line?

The last numeric column. Everything before it is drawn as bars, so arrange your columns as: category, the bar series, then the line series.

What if my line has a very different scale?

When the bars are more than ten times larger than the line, the line moves to a secondary axis on the right with its own scale, and the two are drawn side by side.

Will the combo chart stay editable in Excel?

Yes — the .xlsx contains a real combo chart (a bar chart plus a line chart sharing the axes), so editing a value updates the chart.

Other chart makers