Stacked Column Charts

[jaaret]

I've created a stacked column chart in Excel that displays the minimum to maximum range of several categories. I want to create the same thing in an Access report but it appears that the Access graph applet can only build basic column charts, not stacked column charts. Is this correct? (I hope not.)

Thanks,
Jaaret

 

[jaaret]

Never mind - I found the spot in the Applet to change a basic bar chart to a stacked one. Now my problem is when I open the chart in design view the stacked bars are not visible. (?!) They display in print preview mode but not in design view. How can I get them to display in design mode so that I can format them?

Jaaret

 

[dhookom]

The chart has a Row Source property which you can view in datasheet view. Copy the data and then paste it into the datasheet of the chart control. Then save the chart control and report.

Duane
Hook'D on Access
MS Access MVP