Chart data via a Combo Box?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Chart data via a Combo Box?

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a spreadsheet that is layed out in the following way:

    Column A - Date
    Column B - Name
    Column C - Data1
    Column D - Data2

    I would like to chart the above data based on a selection within a combo box. The combo box setup is easy. How do i chart the data based on what is selected in the combo? The combo displays the Name by the way. I would like for the chart to display all rows of data corresponding to the name selected. Is this ok or is there a better way? Lend me your expertise and guidance. Thank you,

    Waxaholic

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Waxaholic

    Have a look here:
    http://www.ozgrid.com/download/default.htm

    Under:
    ChangingCombo.zip
    ChangingCombo2.zip
    ChartByMonth.zip

    I think you will find some functions there you could adapt.

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thank you. That should work just fine. I had tried your "Changing Range Chart" prior to posting this and liked it alot. It will come in handy.

    Waxaholic

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com