+ Reply to Thread
Results 1 to 6 of 6

Dynamic chart ??? VBA

  1. #1
    Registered User
    Join Date
    11-03-2012
    Location
    Poland
    MS-Off Ver
    Excel 2003 Excel 2007
    Posts
    11

    Question Dynamic chart ??? VBA

    Hi i want to make a dynamic chart but i am stuck.... i do not know how to make it work ???

    Here is the file it will be easier to show what i wanna do then write all about it.....


    there is some VBA coding inside the file....


    ps pivot table is no good for me.... :/






    Any HLelp Would be great.... Greetz
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Dynamic chart ??? VBA

    This might be something for you:
    http://www.excelforum.com/excel-char...-function.html

    I like what you are trying to do but I don't have time to look at it in a couple of days.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Dynamic chart ??? VBA

    This turned out pretty well actually. I made a named range that refers to:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    In cell K3 I build up the name of a table data column like this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    J3 contains a datavalidation from the header of the table so that the country can be chosen.

    And finally the title of the chart is linked to J3. Just a matter of selecting the title, type = and pick a cell.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-03-2012
    Location
    Poland
    MS-Off Ver
    Excel 2003 Excel 2007
    Posts
    11

    Re: Dynamic chart ??? VBA

    jacc it works great on excel2007 but on my work pc on excel2003 i cant see the (x value) on the chart ( it is empty) aby idea why ..???
    Last edited by Rmag; 11-10-2012 at 01:27 AM.

  5. #5
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Dynamic chart ??? VBA

    Excel 2007 introduced the concept of Tables, in Excel 2010 some further updates were made. The forerunner of this feature in Excel 2003 was referred to as a List. And that's about all I know.
    Maybe some feature or some way of referencing that I did is not compatible with Excel 2003. I googled it quite a bit without finding out much.

    Hey, experienced Excelers! It would be really cool if any of you could step in and clarify this. I want to know the answer just as much as TS.

  6. #6
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Dynamic chart ??? VBA

    A slight upgrade. I defined a new variable, Header, like this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I then used Header as the List for the datavalidation.
    This way the dropdown menu always contains all countries even if new ones are added, while keeping the date column out.
    Attached Files Attached Files

+ 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.6.0 RC 1