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.
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,673
Messages
5,838,706
Members
430,565
Latest member
cheredia

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