Adding stacked bar chart to report

  • Thread starter Thread starter odubya
  • Start date Start date
O

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.
 
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.
Click to expand...

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.
 
Back
Top