May 31, 201213 yr I am new to using FileMaker's charting feature and I am having a trouble creating a very simple pie chart. Can someone please tell me how this most basic of basic pie chart examples is done? I have a database with a single table and a single number field: how_much_pizza_did_you_eat If the user enters 25 I want to see 25% of the pie filled in. If the user enters 38 I want to see 38% of the pie filled in, etc
May 31, 201213 yr A pie chart compares values with each other. You need to have another value which will be the remainder of the 100%. Use both blue for the pie chart. Assuming the user entry is a field called "slice" then use the calculation: slice & "¶" & 100 - slice Make the chart with this field, use the delimited text option.
May 31, 201213 yr Author Thanks Vaughan. It's very frustrating, I just can't get it to work for some reason. There must be a simple option that I am failing to set properly. I have a field called "slice" and I am using your exact formula: ChartTest::slice & "¶" & 100 - ChartTest::slice As soon as I switch the data source to "delimited text" the chart goes blank.
May 31, 201213 yr Author The result is: 25 75 You also need two values for labels. Ugh, that was it. Thanks very much. I thought that the labels were only required if I wanted "text labels".
May 31, 201213 yr Author Is there any way to make the chart fill it's rectangle, edge to edge? Currently my pie chart is only about 30% the size of the field. I need to put the charts into a portal and the current size ratio makes it unusable. I have tried turning off all of the extra content but it does not appear to have any impact on the size of the graphic.
May 31, 201213 yr Author Try reducing the font size of all unused parts (labels, legend, title, etc.). Reducing the font size did help but it's still only a couple of points in diameter when I reduce the field down to the size that I need (approximately 85 x 85pt). Perhaps I can edit the clipboard data and get the chart to display edge to edge.
May 31, 201213 yr For such a small size you may be better off using a web viewer. Or go back in time even further and select a picture to show out of say 20 or 30 possibles.
June 1, 201213 yr Author For such a small size you may be better off using a web viewer. Or go back in time even further and select a picture to show out of say 20 or 30 possibles. I am using the picture option now. The solution is running on FMGO 12. I was hoping that I would get a little better performance over the network by using a pie chart.
Create an account or sign in to comment