Need help creating a very simple pie chart. How much pizza did you eat?

[HALBURN]

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

[Vaughan]

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.

[HALBURN]

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.

[Vaughan]

Check the result of the calculation.

[comment]

You also need two values for labels.

[HALBURN]

The result is:

25

75

  On 5/31/2012 at 6:05 AM, comment said:

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".

[HALBURN]

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.

[comment]

Try reducing the font size of all unused parts (labels, legend, title, etc.).

[HALBURN]

  On 5/31/2012 at 7:21 AM, comment said:

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.

[comment]

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.

[HALBURN]

  On 5/31/2012 at 9:51 PM, comment said:

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.