Macro to auto-generate charts & put in PPT slides

F

Freitag

Board Regular
Joined
Jan 26, 2008
Messages
108
I have never done VB or VBA programming, but know that I willI need a macro that will automatically generate over 1000 charts & then export them in pairs (based on ID) to a PPT slide. My data will be in an Excel spreadsheet with approximately 525 rows & 5 columns (ID & 4 data fields associated w/that ID). From the 4 columns of data per ID, I need to generate 2 bar charts & then send both of the bar charts to a PPT slide (for a total of 2 charts/slide on 525 slides). Can anyone help with this? :confused:
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
You must log in or register to reply here.

Similar threads

C
  • Question
Macro which generates Powerpoint slides
Replies
2
Views
567
sijpie
sijpie
K
  • Question
Need to create/source a macro/vba/program that auto populates info based on matching word criteria for community support agency
Replies
3
Views
456
Micron
M
J
  • Question
Macro for copying data from multiple sheets to a common sheet based on a cell value
Replies
0
Views
215
jmk15315
J
D
  • Question
Problems Encountered When Generating VBA Excel Charts with 15-Minute Interval Data.
Replies
0
Views
158
dilshod_k
D
D
  • Question
Move data from one sheet to mutlipe sheets based on sheet name
Replies
3
Views
501
Herakles
H

Forum statistics

Threads
1,215,035
Messages
6,122,785
Members
449,095
Latest member
m_smith_solihull

Share this page

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
Back
Top