Average Customer Spending

[Paul Speirs]

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

[Debra Dalgleish]

On the worksheet, e.g. in cells E2:E31, list the numbers 1-30
In cell F1, enter a heading, e.g. Freq
Select the cells to the right of this list, e.g. cell F2:F31
Enter an array formula to calculate the frequency of each number:
=FREQUENCY(INT(A1:A500),E2:E31)
Press Ctrl+Shift+Enter, to array-enter the formula

Create a chart from the frequency headings and data (E1:F31)

Paul Speirs wrote:
> 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
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html