generate a chart report

[smahdih]

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??

[June7]

Chart type: line with markers

Chart row source: SELECT OrderCode, LeadTime, HourDiff FROM query;

[smahdih]

Chart type: line with markers

Chart row source: SELECT OrderCode, LeadTime, HourDiff FROM query;

i can't find chart type line with markers

find line chart(below pic) but this is not my object

[June7]

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.

[smahdih]

thanks for help , it worked....