Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Selectively Displaying a Data Series on a Chart

  1. #1
    New Member Geronimo's Avatar
    Join Date
    Mar 2002
    Location
    Toledo, OH
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a spreadsheet which has 5 columns of data in columns B thru F in rows 3 thru 33. I wish to construct a chart with a combo box from which I can select any of the 5 columns of data, or all 5 columns, as a Data Series to display on the chart. Is it best to use a formula or VBA? Please advise!! Thank you for your kind attention & help! I appreciate it.

    [ This Message was edited by: Geronimo on 2002-04-09 15:33 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Either way

  3. #3
    New Member Geronimo's Avatar
    Join Date
    Mar 2002
    Location
    Toledo, OH
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I guess I was not clear enough. Is there a formula that will do the job & what is it. Thanks

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-09 15:52, Geronimo wrote:
    I guess I was not clear enough. Is there a formula that will do the job & what is it. Thanks
    What's the value that your combo box will produce? What kind of chart?

    [ This Message was edited by: Mark W. on 2002-04-09 15:55 ]

  5. #5
    New Member Geronimo's Avatar
    Join Date
    Mar 2002
    Location
    Toledo, OH
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I wish to use a line chart plotting numerical values from the columns against days of the month in the rows.

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-09 16:01, Geronimo wrote:
    I wish to use a line chart plotting numerical values from the columns against days of the month in the rows.
    You had better supply some sample data... And, what's the value that your combo box will produce?

  7. #7
    New Member Geronimo's Avatar
    Join Date
    Mar 2002
    Location
    Toledo, OH
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Date Morning Afternoon Evening Night
    4/1/2002 124.0 126.0 119.0 177.0

    4/2/2002 137.0 117.0 140.0 175.0
    4/3/2002 118.0 112.0 106.0 199.0
    4/4/2002 115.0 145.0 131.0 167.0
    4/5/2002 112.0 114.0 136.0 192.0
    4/6/2002 134.0 113.0 116.0 167.0
    4/7/2002 84.0 82.0 111.0 184.0

    Here is a small section of the spreadsheet. I want to choose from a combo box on the chart any one or all of the column headings & display the numerical data on a line chart.One axis has the column headings & the other the day of the month, 1 or 2, or 3 etc.

    [ This Message was edited by: Geronimo on 2002-04-09 16:21 ]

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What's the contents of the Combo Box's input range and what is its cell link?

    [ This Message was edited by: Mark W. on 2002-04-09 16:27 ]

  9. #9
    New Member Geronimo's Avatar
    Join Date
    Mar 2002
    Location
    Toledo, OH
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm not quite sure what you mean.

  10. #10
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    See the Excel Help Index topic for "About control properties for list boxes and combo boxes".

Some videos you may like

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
  •