I'm trying to create a Pie Chart in Access but I'm having issues. Here is a
sample of how my query table is set up

Column Headings: Month, Type 1, Type 2, Type 3
The way my data is formated: May 4 5 6
June 3 2
1

I'm trying to make it so that the date that makes up the pie Chart is the
Type 1, Type 2, Type 3 #'s. My query is set up to request the time frame.
When I try to use the chart wizard it won't allow me to select more than 1
column. It only let me choose Type 1, Type 2, or Type 3 and it won't let me
select the others so that they all show in the pie chart.

What am I doing wrong?

Hi,

This probably has something to do with the fact that it appears that you are
trying to plot more than one series on a pie. Excel will let you select more
than one but it will only plot one. Access may not even allow more than one.
Try a doughnut chart, or a column chart type. Also you might try plotting
the data in Excel and see what you get, just for kicks...

I would recommend that you post this to the Access group on this site.
There is a whole area dedicated to Access, and they will probably provide
better solutions than we can (speaking for myself)

--
Thanks,
Shane Devenshire


"Antavas" wrote:

I'm trying to create a Pie Chart in Access but I'm having issues. Here is a
sample of how my query table is set up

Column Headings: Month, Type 1, Type 2, Type 3
The way my data is formated: May 4 5 6
June 3 2
1

I'm trying to make it so that the date that makes up the pie Chart is the
Type 1, Type 2, Type 3 #'s. My query is set up to request the time frame.
When I try to use the chart wizard it won't allow me to select more than 1
column. It only let me choose Type 1, Type 2, or Type 3 and it won't let me
select the others so that they all show in the pie chart.

What am I doing wrong?