I want to create a stacked column chart in MS Access 2010. I have created a basic column chart using the create design and adding a chart from the menu bar. i have selected the 2 data series that i want but can only display one using the 'wizard'. However, if i save the chart and then double click on the chart i can change the chart type to a stacked column. All seems fine except i cannot display the 2nd series.
Any ideas how i can either add the 2nd series to the underlying data table (and retain the link to the data field in the database) or display the 2nd field during the chart creation using the 'wizard'?
Any ideas how i can either add the 2nd series to the underlying data table (and retain the link to the data field in the database) or display the 2nd field during the chart creation using the 'wizard'?