hi
i have a query like below and want generate a chart base on it
how can i create a chart in access like below chart??
hi
i have a query like below and want generate a chart base on it
how can i create a chart in access like below chart??
Chart type: line with markers
Chart row source: SELECT OrderCode, LeadTime, HourDiff FROM query;
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Here is what I did:
After the chart created, in design view, double click to select it, right click, ChartType>Line>with markers, then built RowSource sql in the properties sheet.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
thanks for help , it worked....