E
Eliza
I created a Pivot Chart Form that calculates average Responses (Data Area) to
different Categories of questions (Category Area). I managed to set different
colors for each Repondent (Series) but when I create this form as a Subform
in a Report, the colors keep on changing back to default colors. How can I
create a report that shows graphs by Category of Question and Type of
Respondent, that will use the same color bars in each graph e.g Manager=Red,
Subordinate=Yellow, etc? Is there a way to get graphs in Reports directly
from Queries and not having to go through Forms? Please help!
different Categories of questions (Category Area). I managed to set different
colors for each Repondent (Series) but when I create this form as a Subform
in a Report, the colors keep on changing back to default colors. How can I
create a report that shows graphs by Category of Question and Type of
Respondent, that will use the same color bars in each graph e.g Manager=Red,
Subordinate=Yellow, etc? Is there a way to get graphs in Reports directly
from Queries and not having to go through Forms? Please help!