ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Charting from Access - challenge (https://www.excelbanter.com/charts-charting-excel/229120-charting-access-challenge.html)

Ana via OfficeKB.com

Charting from Access - challenge
 
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

--
Message posted via http://www.officekb.com



All times are GMT +1. The time now is 10:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com