Using VB to produce a specifc set of data points from a range - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Using VB to produce a specifc set of data points from a range

QuantsQuants Posts: 1Member
I have an excel spreadsheet which is updated regularly. It contains 3 columns, Class, X-data, Y-Data, there are approimately 100 rows of data which can be divided into say 5 classes or groups which I use as the series names. However these classes can change. Is there a way I can plot an x-y scatter graph for each graph where it automatically updates. I was thinking of something Like if class = 11B then plot X Y for series 11B.

Comments

  • kern68kern68 Posts: 85Member
    : I have an excel spreadsheet which is updated regularly. It contains
    : 3 columns, Class, X-data, Y-Data, there are approimately 100 rows of
    : data which can be divided into say 5 classes or groups which I use
    : as the series names. However these classes can change. Is there a
    : way I can plot an x-y scatter graph for each graph where it
    : automatically updates. I was thinking of something Like if class =
    : 11B then plot X Y for series 11B.
    :
    Check out this newsgroup:

    microsoft.public.excel.programming

    Thinking this newsgroup will be a better place for your query.

    GeoK
    [italic]Blah,[/italic][b]Blah,[/b][b][italic]Blah[/italic]!![/b]
Sign In or Register to comment.