Hello

I have 2 tables, one is called income, one is called expenditure. Each table has 3 columns, Day/Description/Cost

For example:
day Description Cost
2 fuel 5
3 paper 21
3 fuel 13
4 electric 25

The above example is for expenditure, the income is identical in layout so you should get the jist of it.

I want to have a line graph that automatically populates when I input the information into the 2 tables showing the income and expenditure against each other. I would like the bottom axis to display the day values and the y upright axis to display the amount. I can pretty do this but when I have 2 items which fall on the same day it putts the day in twice on the bottom axis. Is there a way so if multiple items do fasll on the same day then it will simply total the values to give one valve so there is still only one unique day on the bottom axxis? at the moment day 3 would be repeated on my graph :-(

any help would be great