Chart Macro

[Broxterman]

Hello,
I am having trouble creating a macro that will extract data from on
page of a worksheet and then create a pie chart on another page. Th
problem occurs when I attempt to resize the chart to fit in
designated area. Any help would be greatly appreciated.

Page 2:
Data to be extracted from cells B34:C39.

Page 1:
Create Pie chart with chart name "Data."
No legend.
Show "Label and Percent" for labels.
Chart should fill F7:J18 and be as large as possible

 

[Tom Ogilvy]

Turn on the macro recorder and do it manually. Then generalize the code to
suit your needs.

 

[Broxterman]

I have done that already. My macro will create the chart on the pag
that I want, but it will not allow me to resize it to fit in the area
want. I don't know what code to use to resize the chart to fit in th
desired area.

Is there a way to assign a chart to a specified area?
Again thank you for your assistanc

 

[Tom Ogilvy]

With Activesheet.ChartObjects(1)
.Left = Range("B9").Left
.Top = Range("B9").Top
.Width = Range("M20").Left - Range("B9").Left
.Height = Range("M20").Top - Range("B9").Top
End With