Form Chart changes as attached

[aman]

Please See below the query data my chart is linked to:
Staff Name ActionDue Late
Anthony Fisher 25 17
Rebecca Evans 23 3
Claire Pearce 22 0
Iain Pye 17 5
Simon Woolf 15 3
Andrew Claxton 14 3
Ricki Hale 13 1
Nick Smith 9 4
David Packer 8 4
Lawreen Silongwe 3 0
Victoria Hole 1 0
Rob Phelan 1 0

At the moment my Chart looks like attached Access Chart. But I want it to look like attached Chart Data excel workbook.

Any help will be much appreciated.

Many Thanks

 

[Isskint]

hi aman

As i understand it Excel and Access both use the MSGraph 'engine', so yes you can do the same thing in Access.

I find it best to add second axis the chart by hand rather than using the wizards (i do not even know if/where the options are)

1. double-click on the chart object in the form design view to select it
2. right-click on the data series you wish to show on a secondary axis
3. from the shortcut menu --> Format Data Series
4. Axis tab
5. Plot series on --> Secondary axis

Getting the exact appearance you are looking for may be trial and error through the formatting options exposed after double-click on the chart object.

TBH, I resort to Excel for 'fancy'/complex graphing reports...