Before I get started I would like some feedback if there is an easy way of creating some charts (I have a history of over-complicating things 
)
I have some survey results that I need to create some charts from and am getting in a muddle. I have one large table that contains all the survey results and each question looks something like :
Field name = Q1
2001
2007
2007
2004
2007
As a pie chart I would expect this to show :
2001 = 20%
2004 = 20%
2007 = 60%
However the only way I've found to make this chart is to create a query:
SELECT Tble_Survey.Q1, Count(Tble_Survey.Q1) AS CountOfQ1
FROM Tble_Survey
GROUP BY Tble_Survey.Q1;
and then create a chart using the Chart Wizard into a report. However whenever I want to edit the report it always looks the same way [picture attached] and I have to go through :
----- right click
----- chart object
----- open
This opens Microsoft Graph and I can edit the chart, even though it doesn't look like my chart ?
Please tell me there is a better way !
)I have some survey results that I need to create some charts from and am getting in a muddle. I have one large table that contains all the survey results and each question looks something like :
Field name = Q1
2001
2007
2007
2004
2007
As a pie chart I would expect this to show :
2001 = 20%
2004 = 20%
2007 = 60%
However the only way I've found to make this chart is to create a query:
SELECT Tble_Survey.Q1, Count(Tble_Survey.Q1) AS CountOfQ1
FROM Tble_Survey
GROUP BY Tble_Survey.Q1;
and then create a chart using the Chart Wizard into a report. However whenever I want to edit the report it always looks the same way [picture attached] and I have to go through :
----- right click
----- chart object
----- open
This opens Microsoft Graph and I can edit the chart, even though it doesn't look like my chart ?
Please tell me there is a better way !
