0 Replies Latest reply on Jul 20, 2007 8:38 AM by sir1

    Pie Chart displaying percentages

      Good Morning,

      I'm hoping someone has had experience creating a pie chart with percentage values and is wiling to offer some assistance because I've tried many ways and still came up short.

      The data table I'm using contains two columns: type (A, B, C, etc) and amount (100, 250, etc).

      In order to create a chart showing what percent of the whole each type is, I need to sum all the amounts for all types then divide each type by the sum of all amounts (to create each slice).

      Any suggestions on how to do this through CFquery and CFchart?

      Thanks in advance,
      Sue