generate two charts on one slide in ppt using vba

**spurthi008** · 10-04-2012, 05:22 AM

hello everyone, i need a code for counting number of chart object and ploting 2 charts per each slide in ppt using vba...please help me out..

**NickyC** · 10-04-2012, 06:14 AM

This macro will count your chart objects:

Please Login or Register  to view this content.

when you say you want to plot 2 charts per slide, what do you mean? This code adds 2 charts to a slide:

Please Login or Register  to view this content.

**spurthi008** · 10-04-2012, 08:02 AM

thanks nickyC for ur reply ..but it is not the correct answer which i need here down i vl post my code

From these i can able to generate chart on each slide but i need bit modification that to generate 2 charts per each slide.For that we need to count number of chart from sheet and put in a loop in sucha way that it has to take 2 chart and adjust in one slide instead of taking one slide..

**NickyC** · 10-04-2012, 09:04 PM

Hi
can I suggest you put your code in code marks, or a moderator might intervene
wha's in file D:\xyz.pptx ?

**spurthi008** · 10-10-2012, 05:43 AM

hello...

i got the solution for above forum.
it can be done by calling chartsname i.ee..
if obt. chartName like "*xyz*" then
add slide
adjust the position to the chart.
end if.