LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"