Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|