Stacked column and line chart

[Soumya]

Hello All,

I have a requirement where to use both stacked and line graph in a single chart in Access 2010(64-bit) Version as shown below. Can anyone please help.





Thanks,


Soumya.

[June7]

Might have to do two charts overlaying each other. The top one would be set transparent and only one of them would have axis labels. Or one would have the left Y and the other the right Y.

I just discovered that Line-Column on 2 Axes is a Custom Type. You will not see this with the chart wizard. Have to let the wizard create a chart - any type will do. Then manually edit the chart object to change type and set the RowSource and other properties. However, not seeing option for stacked bar with line.