Chart From Different Summary Fields

[AnthonyDixon]

Hi everyone,

 

Stumped again and totally new to charting. I have a simple calculation field that gives the difference between two

date fields in days, then I have three counter fields that determines which three categories the record will be placed

0 -10 Days, 11- 30 Days, Over 30 Days and three summary fields to display the totals of each category for the

found set. I am trying to create a chart using the three different summary fields and I'm not sure how or if I can

accomplish this. I have attempted various approaches with no success. Thank you for any help or suggestions.

 

Thanks Again

Tony

 

FMP 12 Adv. Mac/Win

Summary Chart.zip

[bruceR]

One solution is to use the Current Record (delimited data) option. See attached.

Summary Chart.fmp12.zip

[AnthonyDixon]

First of all thank you for your help and solution. That will work for me. I was unaware that I could use

the list command, I thought each axis had to be an individual field value. I follow the solution you gave in

your sample file, I get the logic of y-axis, but I am still a bit confused about the x-axis just listing text

values. Sorry a little new to this.

 

Thanks again for your reply and help.