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

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

Summary Chart.fmp12.zip

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.