5 Replies Latest reply on Oct 29, 2013 1:52 PM by philmodjunk

    Making a pie chart from counts.

    jc08

      Title

      Making a pie chart from counts.

      Post

           We have a table that has leading counts at the top of each column. We want to make a pie chart from those counts, but we can not figure out how to use them as our data.

        • 1. Re: Making a pie chart from counts.
          philmodjunk

               By "leading counts" do you mean that you have a summary field that provides these counts--one subtotal for each sorted group of records?

               If so...

               If you can't make the following general description work for you, please use Post a new Answer to tell me what version of FIleMaker you are using as the interface for setting up a chart is different in each version.

               Refer to the summary field as your Y series data. Specify "Summarized data", "sorted groups" as the data source option for your chart. Then be sure to use a find and a sort to pull together the records that you want to chart, sorted into the groups that you want to represent each wedge of the pie chart.

               (It may help to think of each "wedge" of the chart as a special kind of sub summary layout part if you are familiar with how that layout part is used in a report.)

          • 2. Re: Making a pie chart from counts.
            jc08

                 I forgot to mention, I am using FM12.

            • 3. Re: Making a pie chart from counts.
              philmodjunk

                   Specify the summary field in "Slice Data". Then click Data Source and select "Current Found Se"t from the Slice Data drop down and also select the radio button for "Summarized groups of records".

              • 4. Re: Making a pie chart from counts.
                jc08

                     We used a leading grand summary. Whenever I try to make a chart from the 9 counts, I get every entry charted instead of the 9 counts.

                • 5. Re: Making a pie chart from counts.
                  philmodjunk

                       You have to sort your records to group them by whatever field stores the value that identifies each "wedge" in your chart.