WinterRose
New Member
- Joined
- Dec 17, 2020
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
- MacOS
Hello,
I am a newbie working with VBA on Excel. I have been trying to figure out to create a pie chart and a column chart using the following data to show expenses by locations. How would I create a chart that shows expenses based on each location in VBA?
I am a newbie working with VBA on Excel. I have been trying to figure out to create a pie chart and a column chart using the following data to show expenses by locations. How would I create a chart that shows expenses based on each location in VBA?
Distribution Centers Budget Proposal for 2021 | |||||||
Locations | |||||||
Expenses | Cerritos | Santa Monica | Culver City | El Segundo | Total | ||
Rent | $ 12,000 | $ 18,000 | $ 15,000 | $ 16,000 | $ 61,000 | ||
Salaries | 150,000 | 175,000 | 165,000 | 155,000 | $ 645,000 | ||
Equipment | 35,000 | 45,000 | 32,000 | 30,000 | $ 142,000 | ||
General Office | 25,250 | 32,150 | 28,156 | 19,250 | $ 104,806 | ||
Advertising | 15,000 | 20,150 | 21,580 | 18,540 | $ 75,270 | ||
Commission | 35,000 | 25,000 | 26,150 | 35,000 | $ 121,150 | ||
Total | $ 272,250 | $ 315,300 | $ 287,886 | $ 273,790 | $ 1,149,226 |