Need a combination bar/line chart in access

[Jo]

I'm working in a company where they combine bar charts with lines and
so I need a secondary x axis to create the chart.

I can do it in excel easily (I am averaging a number for a particular
month/year and machine and then also counting the number of jobs in
that month/year. the average needs to be the bar and the line is the
count.

As I said I can do it in excel but the chart wizard in access is of no
help.

I did, momentarily, insert a activex object (at least I believe it
was) into a form and get a chart object that seemed to have the same
qualities as an excel chart but then, after moving to a different
computer, I lost the reference to the dll and now can't remember what
it was.

I can't find any information on this on the net or any of my books.
Can anyone help me with this?

Thanks so much.

Jo

 

[Duane Hookom]

You can create a chart with the wizard. Then open the report in design view
and double-click the chart control. Select the series you want to change and
select Chart->Chart Type to change it.