Frederic74
asked on
excel spreadsheet, graph
Hi
I have a monthly sales and cancellation summary spreadsheet, please see attached work sheet august(2).. I would like to summarise the number and EUR of Saels per caregory and total and also compare it to cancellations visually and in a table. Additionally I also would need to have a summary per week, I guess in a different table and graph.
Nothing I have tried has got me close to a solution. Any advise would be very much appreciated.
Many thanks
Frederic
Finance-Break-down-Analysis-pppp.xlsx
I have a monthly sales and cancellation summary spreadsheet, please see attached work sheet august(2).. I would like to summarise the number and EUR of Saels per caregory and total and also compare it to cancellations visually and in a table. Additionally I also would need to have a summary per week, I guess in a different table and graph.
Nothing I have tried has got me close to a solution. Any advise would be very much appreciated.
Many thanks
Frederic
Finance-Break-down-Analysis-pppp.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Attaced example shows how you could visually show number & sales + cancellation.
As the numbers are much lower, they need to be plotted on a secondary axis.
Regarding your weekly report, I think Patrick has a very valid suggestion overall.
As the numbers are much lower, they need to be plotted on a secondary axis.
Regarding your weekly report, I think Patrick has a very valid suggestion overall.
Forgot to attach the workbook
Xl0000011.xls
Xl0000011.xls
Pivot Table won't help you for the chart though :-)
BTW: your charts are much too small to get a nice visualisation.
BTW: your charts are much too small to get a nice visualisation.
>>Pivot Table won't help you for the chart though :-)I wouldn't say that: if the PT powers a PivotChart, then it should faciltate the charting: one could see new sales vs cancellations, and depending on how the source data is reconstructed, you could use either a calculated field or a calculated item to see the variance of sales over cancellations...
Could be Patrick, but he will need secondary axis for his amount as it has a complete different dimension.
ASKER
I have added the cancellattions to the sales, please see attached. Does this make it easier?
Finance-Break-down-Analysis-pppp.xlsx
Finance-Break-down-Analysis-pppp.xlsx
ASKER
I have followed your advise and have put all in one table.
I guess a pivot table would mean I do not need my summarising formulas on the top my spreadsheet?
I'm new to pivot tables do you know a good example introducing it to me ideally similar to my spreadsheet?