PDA

View Full Version : VBA Excel Chart to PowerPoint



dlsmart99
12-06-2011, 06:27 PM
Using the VBA Express help number below, I was able to get MS Excel charts to auto-publish to a PowerPoint...it is awesome!!

/kb/getarticle.php?kb_id=370

However, when they come over as images (taken from chart objects) they are missing the seconday Y-axis to the right of the charts.

Any ideas why this is happening and what I can do to fix it?

Bob Phillips
12-07-2011, 02:44 AM
Can you post your workbook with code?

dlsmart99
12-08-2011, 12:55 PM
I added a portion of the code module with the chart itself being created and then the call to the mod to Power Point script that I got from this site.

So the chart is created and it works great...except for the second 'Y' axis.

This help?

mdmackillop
12-08-2011, 02:31 PM
It would be helpful to have some data, and the missing code which will allow the code to run.

dlsmart99
12-09-2011, 06:13 PM
It was a work assignment and I had a lot of things in there I didn't want to clean up...soory for the partial post.

Fixed...as it turns out, the chart region was just too big. By adjusting the chart area (which pulls the secondary Y-axis in with it) it allows it all to fit in the image output to the PowerPoint file.

It was just a size issue...