Create pie chart with macros

Lost_

New Member
Joined
Jan 11, 2014
Messages
1
Hi, I'm trying to do the following in Excel:

create a pie chart in cell A1 based on user input in cell B1, create a pie chart in cell A2 based on input in B2, and repeat this for 100+ other pie charts.

manually changing the data series for each pie chart is taking forever... So I was wondering if there is an easier way? I've never used macros/VBAs before but was guessing if this could be done with a macro?

thank you!! Any help is greatly appreciated.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Latchmaker

Active Member
Joined
Sep 30, 2005
Messages
308
Ok...I will try to explain the basics of charts. a chart requires two pieces of data minimum therefore there would have to be a minimum of two cells not one...each additional piece of data requires a new cell...and this is why the data series has to be changed to reflect this new data.

Charts cannot be placed in a cell...they can be sized to fit a cell but they are not part of that cell
 

Watch MrExcel Video

Forum statistics

Threads
1,123,474
Messages
5,601,872
Members
414,479
Latest member
Beau the dog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top