Create pie chart with macros

[Lost_]

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.

 

[Latchmaker]

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