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?
Can you post your workbook with code?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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?
It would be helpful to have some data, and the missing code which will allow the code to run.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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...
Posting Permissions
Reply With Quote
