Pie Chart - Displaying by Percentages

[dinohorn397192]

I'm have an "Exercise" table that I want to display a pie chart that shows exercise types by percentage. Is this possible?

Basically, my X Label is set to ExerciseType (varchar) and Y Value is set to ExerciseId. Right now, I can only get it to display totals.

Thanks

[dinohorn397192]

I know I can format XLABEL, but I couldn't add anything to the YVALUE. I was hoping I could manipulate it to get the percentage. So for, nothing has worked.


<data>
<dataset style="{font-size:9px;color:#767a7f;}" size="9" width="2" color="#272b4b" label="Dataset%20Label" dotsize="5" opacity="80" abstraction="4" outline="#5a6484" linecolor="#5a6484" type="pie">
<?php do { ?><point >
<label><?php echo($row_WADWCexercise['XLABEL']); ?></label>
<value><?php echo($row_WADWCexercise['YVALUE']); ?></value>
</point><?php } while ($row_WADWCexercise = mysql_fetch_assoc($WADWCexercise)); ?>
</dataset>
</data>

[Jimmy Wu]

Unfortunately its a limitation on the chart that you can't display it as a percentage. You will have to use the decimal representation of the percentage in this case.