I am trying to chart how many miles I drive each month. I have the data in 3
main columns, A shows the date, B shows the reason for trip and C shows the
number of miles driven.
I can chart column C with the X axis displaying monthly. The problem is that
the chart displays a month for every cell in Column C - however I may have a
number of enteries for any given month - therefore the first three cells in
column C may in for the month of June.
Is it possible to make a chart that recognises which date each cell in
column C refers to and to add them and chart the total for that month?

Appreciate any help, thanks

GuyNI