Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
question best way to organze data for this chart
Have product sales data spreadsheet that I need to produce chart for sales
presentation. Data includes sales transactions spread over several months. Sample: Transaction 1 - July 20 $12,000 Transaction 2 - July 25 $25,000 Transaction 3 - Aug 1 $35,000 Transaction 4 - Aug 20 $15,000 etc We have several sales per month at different prices. We'd like to show bar chart by month for sales in groups of $10,000 increments. So each month there should be bars for sales in these ranges: $10,000 - $19,999 $20,000 - $29,999 $30,000 - $39,999 etc. There would be a bar for each group above with the height controlled by number of sales in each price category that month) and would like the total of those sales to appear on the bar and the total number of transactions - how many sales in that category) at the top of that bar. This would repeat for each month being included. I can manually grab the numbers and place in new chart and annotate the totals and count but wondiering how much of that can be automated/done from the chart wizard or options. Summary: if we had 3 sales in one month in the $10,000 - $19,999 range, that bar would be 3 units tall if we had 4 sales in one month in the $20,000 - $29,999 range, that bar would be 4 units tall if we had 2 sales in one month in the $30,000 - $39,999 range, that bar would be 2 units tall Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
question best way to organze data for this chart
Use FREQUENCY to get a summary of how many sales in each category
Make an XY chart of the resulting data. Have a go and come back if you need more help best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MarkB" wrote in message ... Have product sales data spreadsheet that I need to produce chart for sales presentation. Data includes sales transactions spread over several months. Sample: Transaction 1 - July 20 $12,000 Transaction 2 - July 25 $25,000 Transaction 3 - Aug 1 $35,000 Transaction 4 - Aug 20 $15,000 etc We have several sales per month at different prices. We'd like to show bar chart by month for sales in groups of $10,000 increments. So each month there should be bars for sales in these ranges: $10,000 - $19,999 $20,000 - $29,999 $30,000 - $39,999 etc. There would be a bar for each group above with the height controlled by number of sales in each price category that month) and would like the total of those sales to appear on the bar and the total number of transactions - how many sales in that category) at the top of that bar. This would repeat for each month being included. I can manually grab the numbers and place in new chart and annotate the totals and count but wondiering how much of that can be automated/done from the chart wizard or options. Summary: if we had 3 sales in one month in the $10,000 - $19,999 range, that bar would be 3 units tall if we had 4 sales in one month in the $20,000 - $29,999 range, that bar would be 4 units tall if we had 2 sales in one month in the $30,000 - $39,999 range, that bar would be 2 units tall Thanks. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
question best way to organze data for this chart
I tried frequency and read the help screens, but am missing something, I use
the formula =FREQUENCY(C2:C35,E2:E12) in cell E36, but when I enter it, it returns a zero in that cell. noteL: C2 to C25 contains the date, and E2-E12 is where I typed the BIN values. I'm not getting anything useful. "Bernard Liengme" wrote in message ... Use FREQUENCY to get a summary of how many sales in each category Make an XY chart of the resulting data. Have a go and come back if you need more help best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MarkB" wrote in message ... Have product sales data spreadsheet that I need to produce chart for sales presentation. Data includes sales transactions spread over several months. Sample: Transaction 1 - July 20 $12,000 Transaction 2 - July 25 $25,000 Transaction 3 - Aug 1 $35,000 Transaction 4 - Aug 20 $15,000 etc We have several sales per month at different prices. We'd like to show bar chart by month for sales in groups of $10,000 increments. So each month there should be bars for sales in these ranges: $10,000 - $19,999 $20,000 - $29,999 $30,000 - $39,999 etc. There would be a bar for each group above with the height controlled by number of sales in each price category that month) and would like the total of those sales to appear on the bar and the total number of transactions - how many sales in that category) at the top of that bar. This would repeat for each month being included. I can manually grab the numbers and place in new chart and annotate the totals and count but wondiering how much of that can be automated/done from the chart wizard or options. Summary: if we had 3 sales in one month in the $10,000 - $19,999 range, that bar would be 3 units tall if we had 4 sales in one month in the $20,000 - $29,999 range, that bar would be 4 units tall if we had 2 sales in one month in the $30,000 - $39,999 range, that bar would be 2 units tall Thanks. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
question best way to organze data for this chart
If bin is E2:E12, then select F2:F13 (13 to get one extra)
type formula, commit it with CTRL+SHIFT+ENTER as it is an array formula best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MarkB" wrote in message ... I tried frequency and read the help screens, but am missing something, I use the formula =FREQUENCY(C2:C35,E2:E12) in cell E36, but when I enter it, it returns a zero in that cell. noteL: C2 to C25 contains the date, and E2-E12 is where I typed the BIN values. I'm not getting anything useful. "Bernard Liengme" wrote in message ... Use FREQUENCY to get a summary of how many sales in each category Make an XY chart of the resulting data. Have a go and come back if you need more help best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MarkB" wrote in message ... Have product sales data spreadsheet that I need to produce chart for sales presentation. Data includes sales transactions spread over several months. Sample: Transaction 1 - July 20 $12,000 Transaction 2 - July 25 $25,000 Transaction 3 - Aug 1 $35,000 Transaction 4 - Aug 20 $15,000 etc We have several sales per month at different prices. We'd like to show bar chart by month for sales in groups of $10,000 increments. So each month there should be bars for sales in these ranges: $10,000 - $19,999 $20,000 - $29,999 $30,000 - $39,999 etc. There would be a bar for each group above with the height controlled by number of sales in each price category that month) and would like the total of those sales to appear on the bar and the total number of transactions - how many sales in that category) at the top of that bar. This would repeat for each month being included. I can manually grab the numbers and place in new chart and annotate the totals and count but wondiering how much of that can be automated/done from the chart wizard or options. Summary: if we had 3 sales in one month in the $10,000 - $19,999 range, that bar would be 3 units tall if we had 4 sales in one month in the $20,000 - $29,999 range, that bar would be 4 units tall if we had 2 sales in one month in the $30,000 - $39,999 range, that bar would be 2 units tall Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Chart Data Label Format Question | Excel Discussion (Misc queries) | |||
Adding Data Information to a Chart | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |