i have two charts in ms access and i want to combine these two charts in one chart. do you know how i can have two y-axis in ms access charts with two fields for data area. can you help me please?
thank you
Open your form/report in design view, double click on the chart object, click on the bar/column you want to show on the secondary axis, and then right click, choose "Format Data Series" and choose the tab "Axis", then mark "Secondary Axis".