ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Total And grouping (https://www.excelbanter.com/excel-discussion-misc-queries/240825-total-grouping.html)

Candyman

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?

Ivor Davies

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?



All times are GMT +1. The time now is 03:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com