Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Pie chart format point label values
- Thread starter garry1
- Start date
Override the Finish( ) method of the chart:
Sub Finish( )
Super::Finish( )
Dim i as Integer
Dim j as Integer
For j = 0 to DataSetCount - 1
For i = 0 to PointCount - 1
Points(0, i).Label = Format$(Points (0, i).Y, "#,##0.00")
Next
Next
End Sub
Sub Finish( )
Super::Finish( )
Dim i as Integer
Dim j as Integer
For j = 0 to DataSetCount - 1
For i = 0 to PointCount - 1
Points(0, i).Label = Format$(Points (0, i).Y, "#,##0.00")
Next
Next
End Sub
- Thread starter
- #3
I made the changes you mentioned above. I copied the above code to the chart sub finish method. It is formating to two decimal palces but it is displaying all values as 0.00. I think I am doing something wrong. How to fix this.
Thanks so much.
Thanks so much.
I played around with the example pie chart report and was able to get the points to display correctly -- which uses integer values, not doubles -- as 1234.00 You can change the Format to "#,###.00, but you have to have the ".00" to force the place holder in case there is just one value past the decimal point (or no values to the right of the decimal).
You may need to change the PointLabelStyle from numeric to Text. Other than that, it must be somewhere else, possibly your data or your value expression(s).
You may need to change the PointLabelStyle from numeric to Text. Other than that, it must be somewhere else, possibly your data or your value expression(s).
Ravi,
Yes, I got the attachment in me email, but after looking at it and running it, I guess I'm not sure of your problem. One exception is that I opened it in version 7 of Actuate. However, the graph displays the correct values as point labels: 520106.00 and 542296.00. I overrode the OnRead of the data row and added some fractional part to the values, and again the values displayed correctly on the graph.
Is there some other issue, or am I missing something? I apologize if I am. I can load it on my laptop later as I have version 6 on it. I probably can't get to that for another day or so. In the meantime, if you could let me know more specifically what is wrong with the example you sent and what you are trying to get for an end result.
Bill
Yes, I got the attachment in me email, but after looking at it and running it, I guess I'm not sure of your problem. One exception is that I opened it in version 7 of Actuate. However, the graph displays the correct values as point labels: 520106.00 and 542296.00. I overrode the OnRead of the data row and added some fractional part to the values, and again the values displayed correctly on the graph.
Is there some other issue, or am I missing something? I apologize if I am. I can load it on my laptop later as I have version 6 on it. I probably can't get to that for another day or so. In the meantime, if you could let me know more specifically what is wrong with the example you sent and what you are trying to get for an end result.
Bill
Ravi,
I just took a quick look again. On the pie chart, if what you're looking for is numeric point labels for the values of the pie slices, and you want the legend to specify each Status, then you should be using a Summary chart, not a detail chart.
Summary chart properties would be:
- CategoryExp: [OrderTotals.status]
- CategoryLabelExp: [OrderTotals.status]
- YValueExp: Sum([[OrderTotals.OrderTotal])
- PointLabelStyle: ChartNumericLabels
ALL summary charts have to have an equation, such as Sum( ) in the ValueExp field. Try these above properties on your example with a summary chart and let me know if this is what you wanted.
You may also need to do the same for your bar graph. If not, let me know.
Bill
I just took a quick look again. On the pie chart, if what you're looking for is numeric point labels for the values of the pie slices, and you want the legend to specify each Status, then you should be using a Summary chart, not a detail chart.
Summary chart properties would be:
- CategoryExp: [OrderTotals.status]
- CategoryLabelExp: [OrderTotals.status]
- YValueExp: Sum([[OrderTotals.OrderTotal])
- PointLabelStyle: ChartNumericLabels
ALL summary charts have to have an equation, such as Sum( ) in the ValueExp field. Try these above properties on your example with a summary chart and let me know if this is what you wanted.
You may also need to do the same for your bar graph. If not, let me know.
Bill
Hi,
Thx for ur response. But the pie chart doesn' show the correct format. It always shows one decimal if I use numeric labels. If I use text labels, it shows orders.status in the label (Closed and InEvaluation) not the numeric values.
I think it is showing correctly in version 7.
But I just did something similar for bar charts and its working. This is what I did:
FOR i = 0 to PointCount Step 1
Points(0,i).Label = Format( Points(0,i).Y, "0.00" )
NEXT
Thanks.
Thx for ur response. But the pie chart doesn' show the correct format. It always shows one decimal if I use numeric labels. If I use text labels, it shows orders.status in the label (Closed and InEvaluation) not the numeric values.
I think it is showing correctly in version 7.
But I just did something similar for bar charts and its working. This is what I did:
FOR i = 0 to PointCount Step 1
Points(0,i).Label = Format( Points(0,i).Y, "0.00" )
NEXT
Thanks.
I really didn't use version 6; I mainly went from 5 to 7, altho' I do remember reading some posts about bugs in the charts objects in version 6. It might depend on which SP and fix you're running. You can always check with Actuate Support.
- Status
Similar threads
- Locked
- Question