View Single Post
  #1   Report Post  
Paul Speirs
 
Posts: n/a
Default Average Customer Spending

I have a column which contains dollar values from say $1.00 to $30.00. I
need a chart to plot in one dollar increments the percentage for each
dollar. For example, if I have 20 values, and there are 5 values which are
between $1.00 and $1.99 then the chart would show 25% for this range.

the column would look like:

$1.20
$5.33
$2.30
$1.90
$2.30

etc


regards,

Paul