Charting from Access - challenge

[Ana via OfficeKB.com]

Hi,
I have a problem with combining excel charts with access database. All my
tables in access have date in first column and some numeric data in the
others.
I managed to draw the chart but I have problems with axis. y axis should be
the value of the bars (data from the tables) and I constantly get dates. Id
number column is used for the x axis. Everything is mixed and i don't know
how to change all that. I need x axis to be date, y axis to be value and the
bars in the chart to represent series that are made from other columns of the
table.
I can do all this in excel, but I need help with achiving the same in access
code.
Any help would be grate,
thanks in advance.
Ana