Hi,
I am creating a chart for my boss and in the chart there are four two fields that I want to be displayed. Now I want the chart to be broken down by month number in the x-axis and I want to make the series to be the year so that my boss can view the records (broken down by month) for the previous years also and he can perform all this at once.
The following two fields are the fields that I am using as my y-axis:
sum of orders,
sum of changes in orders (if there are any changes made to the orders, for ex.: an additional item added or something similar to it, I am tracking them also.
Now when I tried to do this in access, I got the message that you cannot have more than one field in the y-axis if you have a series in a chart.
Is there anyway I can do this?
Thanks
I am creating a chart for my boss and in the chart there are four two fields that I want to be displayed. Now I want the chart to be broken down by month number in the x-axis and I want to make the series to be the year so that my boss can view the records (broken down by month) for the previous years also and he can perform all this at once.
The following two fields are the fields that I am using as my y-axis:
sum of orders,
sum of changes in orders (if there are any changes made to the orders, for ex.: an additional item added or something similar to it, I am tracking them also.
Now when I tried to do this in access, I got the message that you cannot have more than one field in the y-axis if you have a series in a chart.
Is there anyway I can do this?
Thanks