Axis Titles in an Access Chart
I have a database of trainee evaluations of which the Options are Very Relevant, Relevant or Not Relevant. I am creating a chart in MS Access report and I would like to display all the options on the x axis even if the count is 0 . Currently if you look at the attached file course Id 1 does not have any trainee listing the course as relevant so it does not appear. Course ID 2 has all the values but only because the trainees have selected at least one of each.
Is there a way to make the axis show all possible options even if they are a null value?
Any help appreciated
DBCharts.accdb
Is there a way to make the axis show all possible options even if they are a null value?
Any help appreciated
DBCharts.accdb
...and since you only have one series, you can delete the legend and add the same data to the chart Title
Access-EEQ27990845ShowAllFieldsC.accdb
Access-EEQ27990845ShowAllFieldsC.accdb
ASKER
Yes this is what I need but can you give me brief instructions on where I went wrong so that I would be able to replicate it again? Also I now I have two charts for each course ID I guess I can just delete mine? The charts in Access are not very intuitive.
Regards
Tricia
Regards
Tricia
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks I did look at Capricorns but the teacher wanted the labels along the x-axis.
Many thanks from "Bonnie Scotland" :-)
Many thanks from "Bonnie Scotland" :-)
Se do bheatha
DBChartsRev.accdb