Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total And grouping
I'm trying to develop a sales chart in which for the month of May 25 items
were sold; there are certain age groupings to create bucket for this report. Days to Sell, can be grouped into 0-15 days; 16-25 days; 36-45 days. Im trying to graph on paper and a chart that €˜Bob had 25 total sales; 0-15 had 12% of the sales, 16-25 had 35% and 25-35 days had 53%. The sales figure would go on the top with a line graph, while the distribution is in bars on the bottom grouped per month. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total And grouping
It is possible but I wouldn't use a line graph to do it. A Pie chart would
be more effective in displaying this information wouldn't it? Alternatively a Stacked Column or Bar graph would do the same thing "Candyman" wrote: I'm trying to develop a sales chart in which for the month of May 25 items were sold; there are certain age groupings to create bucket for this report. Days to Sell, can be grouped into 0-15 days; 16-25 days; 36-45 days. Im trying to graph on paper and a chart that €˜Bob had 25 total sales; 0-15 had 12% of the sales, 16-25 had 35% and 25-35 days had 53%. The sales figure would go on the top with a line graph, while the distribution is in bars on the bottom grouped per month. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
Total column changes colors when total equals sum of other columns | New Users to Excel | |||
calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions |