I have a report which is grouped by a column "color". I want to insert a pie chart in group header for each of the group showing how each color's composition, eg. Red contains 30% a, 25% b, 20%c, etc.
The chart I did is good except it has 'For Red' and 'For Yellow' as subtitle on each of the chart. I just want to show 'Red', 'Yellow'. However, it seems difficult to get rid of the 'For', it uses auto-text in chart expert->Text like "For @Color", if I disable auto-text and write "@color", the subtitle just shows "@color", it doesn't dynamically replace the color with red, yellow..
Can anybody help me out? Thanks a lot
The chart I did is good except it has 'For Red' and 'For Yellow' as subtitle on each of the chart. I just want to show 'Red', 'Yellow'. However, it seems difficult to get rid of the 'For', it uses auto-text in chart expert->Text like "For @Color", if I disable auto-text and write "@color", the subtitle just shows "@color", it doesn't dynamically replace the color with red, yellow..
Can anybody help me out? Thanks a lot