Ok so ive got a worksheet, that shows how much work I've done monthly.

There are 12 tabs (jan - Dec) as well as a "Totals" tab.

The totals is where im keeping a running total of work ive done, including this chart.

I cant get a chart setup to show the month along the bottom, and the numbers along the side.

The side numbers would have to go to about 100.

Each of my tabs has a Totals row, that shows how many items ive produced each month.

How do i apply this to a chart? When i create a chart, and select each of the "Totals" rows each month it tells me the data is invalid.

I just want a basic line chart.