Word Pie Chart from VB

Posted on 2004-11-17
Last Modified: 2010-05-02
I am needing to create a Pie Chart in a word document from a VB application using dynamic data can
anybody point me to a website with a good Example of how to do this
Question by:cdthurman
    LVL 9

    Accepted Solution

        These may help

    Inserting an Excel chart into a Word document,289483,sid8_gci956282,00.html

    HOW TO: Automate Word from Visual Basic .NET to Create a New Document


    Author Comment

    Ok Most of that is working for me if you could help me with one thing I want to be able to set the Category (x) axis labels to certain values I have figured out how to do this manually whis is:
    Right click on the chart
    Go to Source Data
    Then the Series Tab
    Then  Category (x) axis labels
    and just enter the values you want but what I need to know is how to do this from code

    Thank you again
    LVL 9

    Expert Comment

        You should be able to get the code by recording a macro while you set the Category (x) axis labels manually. The code of the macro is VBA, so you should be able to see what you need to do in VB.

        Im glad the links were helpful, thanks for the A.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
    This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now