H
hughess7
Hi all
I have a query in Access which displays the number of dealers grouped on
areas and sector colours. Each area has three sectors (red, orange and
green). The count of dealers for the current AND previous month are shown. I
would like to display the results in a chart but I am new to this area and
not having any luck so far. When I add two sets of data (current and
previous) it does not allow me to have a series and an axis?
I want to be able to display each distributor with their three current and
previous sectors compared side by side. Can this be achieved?
Example data in the query:
Country Sector Current Previous
UK Red 34 51
UK Orange 100 115
UK Green 59 78
Germany Red 160 180
Ireland Orange 110 120
Ireland Green 450 430
etc
Thanks in advance for any help.
Sue
I have a query in Access which displays the number of dealers grouped on
areas and sector colours. Each area has three sectors (red, orange and
green). The count of dealers for the current AND previous month are shown. I
would like to display the results in a chart but I am new to this area and
not having any luck so far. When I add two sets of data (current and
previous) it does not allow me to have a series and an axis?
I want to be able to display each distributor with their three current and
previous sectors compared side by side. Can this be achieved?
Example data in the query:
Country Sector Current Previous
UK Red 34 51
UK Orange 100 115
UK Green 59 78
Germany Red 160 180
Ireland Orange 110 120
Ireland Green 450 430
etc
Thanks in advance for any help.
Sue