I have a dataset coming back:
Group GrpAmt
PArent $10.00
Standard $5.00
2 columns and 2 rows come back. Should this be formatted another way?
I have attached to the chart object but I am not getting the expected pie pieces.
Instead I get 2 round circles within each other. Not the doughnut version, changed to that and just got an extra white circle in the center.
How do I get the chart to show me the pieces?
hmm
I added a 3 row of data and I now have 3 pie pieces, but! their equal sizes within the pie.
even though the amts are quite different.
1 says its 9.59%, another says 42.51% and the 3rd says 47.90%
But the pie pieces show up as 1/3 in size!!!
I expected the 1st to be a tiny piece and the other two to be major pieces.
What am I doing wrong?
Hi Deasun,
I attached a sample report that contains a PieChart. It was created through the Wizard in the following way:
Series: Group
Values: Parent
Then you may want to change the DataPointLabel property of the barSeries to:
= Fields.Group + ": $" + Fields.Parent
What does the DataPointLabel have to do with the pie piece's sizes ?
See each pie piece is exactly the same size!
They should be in relation to the % amt.
So the 58.50% should nearly take up 60% of the whole piechart.
Sorry if i am asking dumb ?'s first time playing with this chart.
The way your piechart looks is what I want mine to look like. But as you can see from above image mine does not.
How can I get the sections to match up to their % value of the whole?
It appears my issue was with the Series.barseries1.X property.
I had it set to: Count(Fields.SubGroup), which now makes sense as to way they were all one size. duh!
I reset it to: Fields.GrpAmt and it kinda worked.
It appears a negative bucket was given it a further problem. I only seemed to see half the PieChart.
I took that negative amt out from the datasource and the piechart worked!! :)
Whats the negative amount do that messes it up?
Hi Deasun,
If I understood correctly, there were some negative values in the datasource, is that correct?
In this case, I would recommend using a column or line chart, where the negative values can be presented below the horizontal axis.In order to avoid such issues, you can edit the expression of series' X value, which will return 0 if the current sum is a negative number:
= IIF(Sum(Fields.Value) < 0, 0, Sum(Fields.Value))
Note that having a negative number in the data set will affect the calculation of the other grouping members.