Excel Tips Monster

Formatting the chart data tables

You probably know that you can place a data table under a chart, along with the data’s visualization. It’s called a chart data table.

I agree with datapig’s complaint that the default formatting for such data tables is horrible, and needs fixing.

It’s not that the data isn’t presented right… it’s just hard to read, in an unnecessary way.

He suggests some very simple re-formatting, which makes the table much more readable to anyone who has eyes (e.g. not an OCR ).