+ Reply to Thread
Results 1 to 2 of 2

Thread: Creating a chart from changing input in a seperate sheet

  1. #1
    Registered User
    Join Date
    12-04-2011
    Location
    Ontario
    MS-Off Ver
    Excel 2007
    Posts
    1

    Creating a chart from changing input in a seperate sheet

    Hi all,

    New to the forum and vba.

    I'm working on making a program more-user friendly, and adding more features.

    I have an output sheet spitting out 2 columns of information, including the title.

    ex.
    Label 1
    1
    2
    3

    --If possible, I'm trying to write a code that creates a chart (or activates a hidden one?) and then changes the labels and data in the chart (pie or doublebar) according to the output on the seperate worksheet (changing Label1 and figures)

    I was thinking on having this code "Called" within the steps of the simulation so right when the numbers are generated, the chart is updated, activated, and shown to the user.

    Hope the format of this question is ok, thanks for your time!

  2. #2
    Forum Guru Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007
    Posts
    3,520

    Re: Creating a chart from changing input in a seperate sheet

    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0