I have never worked with graphs in ACCESS until now. I have a problem with a report I am running. I have a graph based off of a survey question. For the field question 1), the graph currently has the counts of yes, no, and don't know. I am trying to also get the graph to show what percentage those counts correspond to (ex. 35% yes, 45% no, 20% don't know)
Currently the unbound object frames' row source is: SELECT [Question C1],Count(*) AS [Count] FROM [qrybigConsumer] GROUP BY [Question C1];
I have tried right clicking on the column in a graph to try and add the data label for percent, but it is grayed out and will not allow me to.
How do I make my table include percentages? Any help is appreciated. Thanks.
Currently the unbound object frames' row source is: SELECT [Question C1],Count(*) AS [Count] FROM [qrybigConsumer] GROUP BY [Question C1];
I have tried right clicking on the column in a graph to try and add the data label for percent, but it is grayed out and will not allow me to.
How do I make my table include percentages? Any help is appreciated. Thanks.
