Solved Graph that shows amount spent per item grouping each year

[Bean Machine]

Hi all! I'm having trouble finding a solid way to create a scatter graph from a query that would show the yearly amount spent on each grouping of items (for example amount spent on wood, computers etc.). I've been using mm/dd/yyyy format for the dates in the table the query is pulling from and I want to isolate just the year and each item grouping to show, in a minimalistic and quick manner, the amount being spent on each grouping throughout the years to show any discrepancies where costs could be reconsidered or recouped. See image for more background on what I'm trying to accomplish.

 

[Ranman256]

make your source query have the fields you need, so convert date to year in the query: year([dateFld])
then have the wizard create the chart,
then edit the chart to tweak it how you need.

 

[Bean Machine]

make your source query have the fields you need, so convert date to year in the query: year([dateFld])
then have the wizard create the chart,
then edit the chart to tweak it how you need.

Thanks! This worked perfectly, now to figure out how to make the chart look better... lol