• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Paste Special

2

2696883

New Member
I would like to use VBA to paste a range of data into an existing chart, using the options shown in the attached screenshot.

If I record a macro whilst doing so manually, the code only states ActiveChart.Paste. Thus, when I re-run this code the series is pasted regularly without the 'Series Name In First Row' deactivated. How can I code this correctly? I haven't found much in the way of help in my research so far.
 

Attachments

  • PasteSpecial.jpg
    PasteSpecial.jpg
    22.7 KB · Views: 8
Hi 26830268

Chart Paste Special is just a short cut to Add Series/Value in Rows/Column, in a chart..
If you Google for.. "Automate Bubble Chart", you will find that code to add Series or values Collection..

PS: By seeing 224*214 pixel image.. I think, above two lines are enough for the time being ..
Please provide more detail with excel file.. for more detail..
 
You must log in or register to reply here.
Back
Top