How to make a chart like this........??

[yoyo881]

Hello, after importing the table, I made 2 separate charts with several bars evenly distrbuted on the x-axis, but what I need is to make a chart with 2 bars that stick together on the x-axis? Then there will be several double bars lie on the chart, how to make it? Need to write SQL?

Besides, I've to sum up the total number of each bar and put the number on top of each bar, as there are large number of data that need to input, I'd like to save time and don't want to make a chart in Excel again to count the total and import it in Access. Any faster method to solve this problem?

Also, as the data will be updated almost daily, how to make the chart to be updated as well?

Thanks!

yoyo