Reference no: EM132862318
Visualization Analysis Investments, $ Sales, $ Research, $ Service, $
Company A 200 250 95 200 Company B 150 820 120 540 Company C 400 900 200 900 Company D 300 200 110 500 Thousands $
1. Add column to the right calculating the total budget for each company.
2. Add columns to the right calculating the % of budget each company spends in the following fields: Investments, Sales, Research, Service.
3. For each company create a pie-chart.
5. Create one bar-chart diagram demonstrating the Amount of money companies spend for each field.
6. Briefly analyse results and make conclusion. In what company do you prefer to work and why?
7. Check that all charts have their titles and axes' names.