Hi,
I have a huge problem designing a chart, where more lines (series) will be displayed. I tried to use PivotChart as well as chart object in the insert menu for forms. The problem is that I have to use conditional count for every serie/line. I based my chart on a query (based on another query). Please take a look at the picture of query provided.
My problem is that I need to put the condition "True" (since 'Aircraft related occurrence' and 'Aerodrome related occurrence' are checkboxes) just for one line everytime... I don't know if I explain it properly... Well, the problem is that those conditions apply overall on the whole query and hence on the whole chart. So I tried to put the condition 'Where' and 'Count' into one field somehow, but I wasn't able to realize that
So what I need to do is something like on the second picture provided, but not just for 'Aircraft related occurrences', but there has to be another line depicting 'Aerodrome related occurrences' in the same chart as well... And this has to be independent on the 'Aircraft related occurrences' True condition.
Another problem is that I need to display months (x-axis) in words, not in numbers, I tried to rename them manually in the datasheet window which appears after doubleclick on the chart. It worked fine, but after I saved the adjusted form with the chart and closed it, after re-opening there were numbers once more, it didn't save the changes made in datasheet window...
I also need to display all months, even if there is 0 value of the number of occurrences, but once more, after changing this manually in datasheet view, it wasn't saved...
Any help is very welcomed, I am becoming to be desperate... 
Thank you very much!
Ivan
I have a huge problem designing a chart, where more lines (series) will be displayed. I tried to use PivotChart as well as chart object in the insert menu for forms. The problem is that I have to use conditional count for every serie/line. I based my chart on a query (based on another query). Please take a look at the picture of query provided.
My problem is that I need to put the condition "True" (since 'Aircraft related occurrence' and 'Aerodrome related occurrence' are checkboxes) just for one line everytime... I don't know if I explain it properly... Well, the problem is that those conditions apply overall on the whole query and hence on the whole chart. So I tried to put the condition 'Where' and 'Count' into one field somehow, but I wasn't able to realize that
So what I need to do is something like on the second picture provided, but not just for 'Aircraft related occurrences', but there has to be another line depicting 'Aerodrome related occurrences' in the same chart as well... And this has to be independent on the 'Aircraft related occurrences' True condition.
Another problem is that I need to display months (x-axis) in words, not in numbers, I tried to rename them manually in the datasheet window which appears after doubleclick on the chart. It worked fine, but after I saved the adjusted form with the chart and closed it, after re-opening there were numbers once more, it didn't save the changes made in datasheet window...
I also need to display all months, even if there is 0 value of the number of occurrences, but once more, after changing this manually in datasheet view, it wasn't saved...
Any help is very welcomed, I am becoming to be desperate...
Thank you very much!
Ivan
