Reply to thread

Message

[QUOTE="jonny, post: 3949636"]
Hi Mark,

I am trying out this chart control and ran into a snag and maybe you
know the answer to this.

I have a sql table with four column named Availability, Performance,
Quality and OEE. I am wanting to make a simple bar graph with each of
the columns having its on bar in the graph. However this is not
exactly the x and y relationship that the .net graph control is
looking for since it wants to see the value and name in separate
columns such as...

COLUMN 1/name         COLUMN 2/value
Availability                              .5
Performance                           .75
Quality                                  .88
OEE                                     .75

Off course if I had the information in a table like above I would have
no problem making the chart since the .net chart control is looking
for this x and y format. However my data is in the table like so...

Column 1/ Availability               Column 2/ Performance     Column
3/ Quality     Column 4/ OEE
..5                                                    .
75                                      .88                        .75

So you see I have to figure out a way to get the chart to read my
table in this format. Do you have any suggestions or examples on how
to get around this. Another program is putting the data into sql this
was so I cannot just change the sql table structure without totally
reprogramming so I have to find away to pull the data out of the table
while in this format.

I really appreciate your help and expertise. Thanks.
[/QUOTE]

Verification