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
|
|||
|
|||
Help In Assigning a color for a value in a Pie Chart
I have a Pie Chart with 2 items only (R or P). R is a dark color and P is a
light color. When There isn't any P in my data, the chart picks the light color for R. I would like to always have a dark color for R and a light color or P. I am doing the chart in MS Access 2000-03 and my row source is: SELECT [RP],Sum([Freq]) AS [SumOfFreq] FROM [Rept#704_Joint_RP] GROUP BY [RP]; Can someone please help me. Thanks, Gary |
#2
|
|||
|
|||
Help In Assigning a color for a value in a Pie Chart
Typically the easiest solution is to use a LEFT or RIGHT JOIN query to
include all values of RP. If that doesn't work, you can use code in the On Format event of the section of the report that contains the chart. I generally record code in Excel and then paste it into Access. This requires a few code updates in Access. -- Duane Hookom Microsoft Access MVP "Gary" wrote: I have a Pie Chart with 2 items only (R or P). R is a dark color and P is a light color. When There isn't any P in my data, the chart picks the light color for R. I would like to always have a dark color for R and a light color or P. I am doing the chart in MS Access 2000-03 and my row source is: SELECT [RP],Sum([Freq]) AS [SumOfFreq] FROM [Rept#704_Joint_RP] GROUP BY [RP]; Can someone please help me. Thanks, Gary |
#3
|
|||
|
|||
Help In Assigning a color for a value in a Pie Chart
Thank You, but I don't completely understand what you are telling me.
1) The the Left or Right Joint query, you indicated include all values of RP. For me, the problem occurs when only R is present and not P is present. The chart takes on the light color in this case. Normally, when I have both R and P occuring, the P takes the light color and the R takes the dark color. How would I use the Right and Left Joint query ??? 2) For the on Format, do you have more information on this?? I do know VBA and its no issue for me to use VBA code, but your solution I don't understand what to so. Any reference or an example from some where ?? Thank You, Gary "Duane Hookom" wrote: Typically the easiest solution is to use a LEFT or RIGHT JOIN query to include all values of RP. If that doesn't work, you can use code in the On Format event of the section of the report that contains the chart. I generally record code in Excel and then paste it into Access. This requires a few code updates in Access. -- Duane Hookom Microsoft Access MVP "Gary" wrote: I have a Pie Chart with 2 items only (R or P). R is a dark color and P is a light color. When There isn't any P in my data, the chart picks the light color for R. I would like to always have a dark color for R and a light color or P. I am doing the chart in MS Access 2000-03 and my row source is: SELECT [RP],Sum([Freq]) AS [SumOfFreq] FROM [Rept#704_Joint_RP] GROUP BY [RP]; Can someone please help me. Thanks, Gary |
#4
|
|||
|
|||
Help In Assigning a color for a value in a Pie Chart
The query is a left or right join. Assuming you have a table or query with
just two records with R and P as records. Add this to your Row Source and join the R and P field with RP. Then double-click the join line and select the option that includes all the records from the R and P table. -- Duane Hookom Microsoft Access MVP "Gary" wrote: Thank You, but I don't completely understand what you are telling me. 1) The the Left or Right Joint query, you indicated include all values of RP. For me, the problem occurs when only R is present and not P is present. The chart takes on the light color in this case. Normally, when I have both R and P occuring, the P takes the light color and the R takes the dark color. How would I use the Right and Left Joint query ??? 2) For the on Format, do you have more information on this?? I do know VBA and its no issue for me to use VBA code, but your solution I don't understand what to so. Any reference or an example from some where ?? Thank You, Gary "Duane Hookom" wrote: Typically the easiest solution is to use a LEFT or RIGHT JOIN query to include all values of RP. If that doesn't work, you can use code in the On Format event of the section of the report that contains the chart. I generally record code in Excel and then paste it into Access. This requires a few code updates in Access. -- Duane Hookom Microsoft Access MVP "Gary" wrote: I have a Pie Chart with 2 items only (R or P). R is a dark color and P is a light color. When There isn't any P in my data, the chart picks the light color for R. I would like to always have a dark color for R and a light color or P. I am doing the chart in MS Access 2000-03 and my row source is: SELECT [RP],Sum([Freq]) AS [SumOfFreq] FROM [Rept#704_Joint_RP] GROUP BY [RP]; Can someone please help me. Thanks, Gary |
Thread Tools | |
Display Modes | |
|
|