Skip to content

Excel charts - It's all in the data

Before you make an Excel chart, check the rows and columns you’ll base it on.

A lot of chart problems are caused by incomplete or badly formatted data.  Excel is smart at turning numbers into charts but it’ll get confused easily.

Have a look at this simple table imported from a web page.

Looks OK but see what happens when you try to make a chart.

Ouch … only three states are shown, values have become the chart title!

The problem is the data, not Excel.  Those population numbers aren’t numbers at all.  They were copied from a web page which Excel considered to be text because there were spaces, not commas, for the thousands.  There were other anomalies that’s we fixed to make this table:

And this chart;

About this author

Office Watch is the independent source of Microsoft Office news, tips and help since 1996. Don't miss our famous free newsletter.