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? 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

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA - How to Create a Visual Basic Macro Chart Based on Expenses

Thread starter WinterRose
Start date Dec 17, 2020
Tags

chart excel vba

WinterRose

New Member

Dec 17, 2020

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?

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