If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pie Chart Troubles
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? |
#2
|
|||
|
|||
Pie Chart Troubles
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? |
Thread Tools | |
Display Modes | |
|
|