Hello,
I have a pie chart bound to a sql data source:
select CarMake, count(*) as CarTotal from Cars group by CarMake
I'm having trouble getting the legend to show each CarMake with its pie piece color. All I get is CarTotal in the legend. How can I change the legend (either in the wizard or the vb code) to show each CarMake? I've tried several different settings in the wizard and haven't found the right solution yet.
Also, how do I get the percentage of total each count is to display on the pie chart? Sorry if this is obvious. I've searched on the forums for a while and haven't been able to find anything that makes mine work.
Thanks,
Ben
I have a pie chart bound to a sql data source:
select CarMake, count(*) as CarTotal from Cars group by CarMake
I'm having trouble getting the legend to show each CarMake with its pie piece color. All I get is CarTotal in the legend. How can I change the legend (either in the wizard or the vb code) to show each CarMake? I've tried several different settings in the wizard and haven't found the right solution yet.
Also, how do I get the percentage of total each count is to display on the pie chart? Sorry if this is obvious. I've searched on the forums for a while and haven't been able to find anything that makes mine work.
Thanks,
Ben