Adding stacked bar chart to report

[odubya]

I want to add a stacked-bar chart to an Access report that is not
accommodated by the standard charting program built into Access. It
is, however, a chart type available in Excel.

So first question is, How would I get such a chart type into an Access
report?

I can see that I can insert an Excel Chart object into the report that
does allow the chart type I need. But the chart in the object is
linked to a worksheet in the Excel object itself, not to the Access
query underlying the report.

So second question is, if embedding an Excel Chart object is the way
to go, then how do I get the queried data into the worksheet?

Thanks.

 

[Rick Brandt]

I want to add a stacked-bar chart to an Access report that is not
accommodated by the standard charting program built into Access. It
is, however, a chart type available in Excel.

So first question is, How would I get such a chart type into an Access
report?

I can see that I can insert an Excel Chart object into the report that
does allow the chart type I need. But the chart in the object is
linked to a worksheet in the Excel object itself, not to the Access
query underlying the report.

So second question is, if embedding an Excel Chart object is the way
to go, then how do I get the queried data into the worksheet?

Thanks.

The charting engine is the same. Just because you don't see a particular
option in the chart wizard does not mean that you cannot create that
particular chart. Pick the closest format in the wizard and then modify the
chart afterwards in the chart designer.