Macros and Charts

  • Thread starter Thread starter Danielle
  • Start date Start date
D

Danielle

Hello folks,

Ok, so here is what I want. I want my charts to have a specific look
(color, font, number of bars, etc...) but I want to run a macro,
create a button to insert it, which I can do...

My problem is that whatever changes I make to the formatting of the
chart while recording the macro, isn't saved in the macro. It just
inserts the same generic chart. What if I want to insert a pie chart
with my colors and fonts, etc... nope... inserts the bar chart.

I know I can save custom charts and make them my default... but I want
other people to be able to use this file... and MY default won't work
for them.

Am I even making sense?! Someone plese help me!

Thanks, Danielle
 
You are in edit mode when you record the macro, correct? Are you still in
edit mode when you play it back?

PowerPoint handles these modes differently in code. Check this FAQ for more
info and the solution:
http://www.rdpslides.com/pptfaq/FAQ00159.htm

Bill Dilworth, Microsoft PPT MVP
===============
Please spend a few minutes checking vestprog2@
out www.pptfaq.com This link will yahoo.
answer most of our questions, before com
you think to ask them.

Change org to com to defuse anti-spam,
ant-virus, anti-nuisance misdirection.
..
..
 
Ok, so here is what I want. I want my charts to have a specific look
(color, font, number of bars, etc...) but I want to run a macro,
create a button to insert it, which I can do...

My problem is that whatever changes I make to the formatting of the
chart while recording the macro, isn't saved in the macro. It just
inserts the same generic chart. What if I want to insert a pie chart
with my colors and fonts, etc... nope... inserts the bar chart.
Click to expand...

PowerPoint's macro recorder records stuff you do in PowerPoint. Not everything
you do there, but *only* things you do there.

When you insert a chart, you're actually invoking a completely different
program, MSGraph, to do the work for you. PPT turns control over to it while
you're creating the graph, then resumes control when you click OFF the graph.

For that reason, PPT won't record any macro code to help you with this.
It's possible to write code that controls MSGraph, but that's a few magnitudes
of complexity beyond recording macros. ;-)
 
Back
Top