How to display chart by row value?

Question

0.00/5 (No votes)

See more:

test1|test2|test3|test4|
125 |143 |144 |123
123 |123 |154 |134

this is a table , usually to show a chart we are taking the columns value ,first column is x axis and second column is y axis...

now my problem is I need to show it according to my table above...is there any code that i can read by row instead of column to show my table above in chart ???
how to show my table above into chart?

Posted 6-Jan-14 16:02pm

acing wei

Add a Solution

Comments

JoCodes 6-Jan-14 22:29pm

There are different kind of charts? What do you need?

acing wei 6-Jan-14 23:06pm

microsoft charting display in column chart...

2 solutions

Solution 3

hi all am also facing same problem plz post some.

in my task is that i have a datagridview i want to read the columns to 2 comboboxs is for x asix other is for y asxis . how to read column name from datagridview combobox and when i select axis from 2 combobox that values should come on chart. i have other combobox3 using that i want change type of chart like column,line,points plz post code to implement this task

note that : using C# and sql only

Posted 12-Jan-14 20:28pm

Member 10478778

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

JoCodes · Accepted Answer · 2014-01-06T16:35:00

Solution 1

Refer

http://www.dotnetfox.com/articles/bind-Asp-Net-chart-control-from-database-using-C-Sharp-1056.aspx[^]

http://blogs.msdn.com/b/alexgor/archive/2009/02/21/data-binding-ms-chart-control.aspx[^]

Shows how to bind the X and Y access according to the Data.

Hope this helps

Adding a sample code snippet as per the comment

C#

string[] x = new string[dt.Columns.Count];
            string[] y = new string[dt.Columns.Count];
            for (int i = 0; i < dt.Columns.Count; i++)
            {
                if (i == 0)
                {
                    //fetching the row values and assigning to stringarray if need integers convert to integers
                    x  = Array.ConvertAll( dt.Rows[i].ItemArray,item=>item.ToString());

                }
                else if (i==1)
                {
                    y = Array.ConvertAll(dt.Rows[i].ItemArray, item => item.ToString());
                }


            }

Note:
Null checks for the items not done, you should take care of those
Now using this try to bind the X and Y axis

Posted 6-Jan-14 16:35pm

JoCodes

Updated 7-Jan-14 17:24pm

v3

Comments

acing wei 6-Jan-14 23:08pm

all of the binding is bind using column...can i read it from row??

JoCodes 6-Jan-14 23:51pm

May be I m not clear . You have a tabular data representation which means it contains columns and rows. What ever row values we have are just corresponding values only.Can you please make it bit clear with an example?

acing wei 7-Jan-14 1:01am

JoCodes 7-Jan-14 1:19am

Table means HTML table control and its first row is the X axis?

acing wei 7-Jan-14 1:24am

table is my new datatable... yes first row is x axis , second and third row is y axis..how to do that?

JoCodes 7-Jan-14 1:53am

You can simply try like dataTable.Rows[0][0] // which denotes first row first column and iterate .

acing wei 7-Jan-14 1:55am

Chart1.DataSource = lstData;
Chart1.Series["pass"].XValueMember = "";
Chart1.Series["pass"].YValueMembers = "";
Chart1.DataBind();
which one? i dont get it

JoCodes 7-Jan-14 2:15am

Post relevant code on how you retrieve the rows and column values and assigning. Logic is just to fetch the row values and add to a list and bind those value to the chart control

JoCodes 7-Jan-14 2:37am

So now dtoutput is the final datatable which you want to show as Row values in chart?

acing wei 7-Jan-14 2:41am

yes.... i need to show by row values....

acing wei 7-Jan-14 2:44am

my chart datasource is using dtoutput.. and the output of above code looks like this
test1|test2|test3|test4|
125 |143 |144 |123 >>> pass value
123 |123 |154 |134 >>>rework value
I need to show the row values in chart..

acing wei 7-Jan-14 7:31am

Can help me sir?

JoCodes 7-Jan-14 23:20pm

Try this code . change the datatypes if required

string[] x = new string[dt.Columns.Count];
string[] y = new string[dt.Columns.Count];
for (int i = 0; i < dt.Columns.Count; i++)
{
if (i == 0)
{
//fetching the row values and assigning to stringarray if need integers convert to integers
x = Array.ConvertAll( dt.Rows[i].ItemArray,item=>item.ToString());

}
else if (i==1)
{
y = Array.ConvertAll(dt.Rows[i].ItemArray, item => item.ToString());
}

}

acing wei 7-Jan-14 23:39pm

y = Array.ConvertAll(dtoutput.Rows[i].ItemArray, item => int.Parse(item));

is this how to convert to integer?? i got this error
"Y values cannot be data bound to the string object"

JoCodes 8-Jan-14 1:26am

Try this but combine both lines into 1 later

var s = Array.ConvertAll(dt.Rows[i].ItemArray, item => item.ToString());
x= s.Select(t => int.Parse(t)).ToArray();

acing wei 8-Jan-14 2:51am

thanks it works...

JoCodes 8-Jan-14 3:46am

You are welcome...Glad to hear that your issue is solved...

acing wei 9-Jan-14 21:39pm

test1|test2|test3|test4| >> testing
125 |143 |144 |123 >>pass
123 |123 |154 |134 >>fail

hay jocodes i need your help..if i want to add another column on the right side with a string..and i use this
System.Data.DataColumn newColumn = new System.Data.DataColumn("Hours", typeof(System.String));
newColumn.DefaultValue = 5;
dtoutput.Columns.Add(newColumn);
Im using this but i don want to count the last column in with the array code x and y above... can you help me with some suggestion?

JoCodes 10-Jan-14 6:13am

sure you can do that with a if condition added. But not clear what you meant by count the last column?Can you please explain.

acing wei 10-Jan-14 9:39am

Hay, I want to add another column beside the test 4 column, like this
Testing|
Pass. |
Fail. |
By using your array code above I can get my x and y value by rows.. but my problem now I actually don't want to my last column this read by the array ... Because this last column don't need to show in my x and y chart.. is it possible to do that?...

JoCodes 12-Jan-14 2:22am

Its possible. Add any columns the same way . and exclude the last column

acing wei 12-Jan-14 20:28pm

yes i added column, but how to ask the array to exclude the last column?

JoCodes 12-Jan-14 22:19pm

Array is index based. so loop till , count-1 which means last item is excluded.

acing wei 12-Jan-14 23:20pm

if (i == 0)
it will count the first row, then what you mean by count-1..i don't get you? sorry, i a bit slow

JoCodes 12-Jan-14 23:31pm

just add one more loop inside the current loop like for (int j = 0; j < dt.Rows.Count-1; j++) and move the i==0 and i==1 conditions inside it

acing wei 13-Jan-14 1:38am

i debug it will always count me my last column after this code
x = Array.ConvertAll( dt.Rows[i].ItemArray,item=>item.ToString());

JoCodes 13-Jan-14 1:43am

where ever you dont want last raow change to dt.Rows[i-1].ItemArray,item=>item.ToString());

acing wei 13-Jan-14 2:00am

it goes to the catch exception when i use [i-1] in array..

Member 10478778 13-Jan-14 2:29am

plz post complete code i also want that i have posted my task plz have a look

acing wei 13-Jan-14 8:53am

dt.Rows[i-1].ItemArray,item=>item.ToString());
it gives error.. i try use dt.Rows[i+1].ItemArray,item=>item.ToString());
it skip away first row.. what i want is to skip my last column.. can guide?

JoCodes 13-Jan-14 22:32pm

change it like
for (int i = 0; i < dt.Columns.Count; i++)
{
if (i == 0)
{

var s = Array.ConvertAll(dt.Rows[i].ItemArray, item => item.ToString()).Take(dt.Columns.Count-1);
x= s.Select(t => int.Parse(t)).ToArray();

}
else if (i==1)
{

y = Array.ConvertAll(dt.Rows[i].ItemArray, item => item.ToString()).Take(dt.Columns.Count-1).ToArray();
}
}

acing wei 13-Jan-14 22:51pm

Thank you so much JoCodes..it works...THANK You..

JoCodes 13-Jan-14 22:59pm

Acing, You are welcome :)

acing wei 28-Jan-14 1:58am

JOCodes, i need your suggestion.. for my charting that i read from array previously. is it possible to do a paging charting like there is a next chart and previous chart button. is it possible? can suggest me?

JoCodes 28-Jan-14 2:05am

That can be complicated too since in that case the array items to display in each page you need to maintain in the previous and next buttons.

acing wei 28-Jan-14 2:56am

I can't find any sample in google. do you have any sample to share?

JoCodes 28-Jan-14 3:13am

Not yet. I ll surely share if I get one.

acing wei 28-Jan-14 4:39am

alright,Thanks and have a nice day...

acing wei 28-Jan-14 5:06am

Jocodes, can help me see and give me some suggestion in the bottom code. i got idea splitting my y into 2 chart. but i don know how my x value split..?

acing wei 28-Jan-14 5:05am

string[] x = new string[dtoutput.Rows.Count];
int[] y1 = new int [dtoutput.Rows.Count];
int[] y2 = new int[dtoutput.Rows.Count];
int[] y3 = new int[dtoutput.Rows.Count];

for (int i = 0; i < dtoutput.Rows.Count; i++)
{

if (i == 0)
{
//fetching the row values and assigning to stringarray
x = Array.ConvertAll(dtoutput.Rows[i].ItemArray, item => item.ToString()).ToArray();
}
else if (i == 1)
{
y1 = Array.ConvertAll(dtoutput.Rows[i].ItemArray, item => Convert.ToInt32(item)).ToArray();
}
else if (i == 2)
{
y2 = Array.ConvertAll(dtoutput.Rows[i].ItemArray, item => Convert.ToInt32(item)).ToArray(); ;
}
else if (i == 3)
{
y3 = Array.ConvertAll(dtoutput.Rows[i].ItemArray, item => Convert.ToInt32(item)).ToArray(); ;
}
Chart1.Series[0].Points.DataBindXY(x, y1);
Chart1.Series[1].Points.DataBindY(y2);
Chart1.Series[2].Points.DataBindY(y3);
i got an idea when button pressed go to another chart.
if i want to put my y3 in different chart how can i split my x value into 2 chart.

JoCodes 28-Jan-14 5:35am

X is?

acing wei 28-Jan-14 19:43pm

X is string output ,contains timing like : 0730,0830,0930,1030
which is read from the first row of my datatable.

JoCodes 28-Jan-14 22:18pm

I think it would be better to put this as new question since the comment thread is increasing.

acing wei 28-Jan-14 23:13pm

Thanks Jocodes for your help in this few weeks, I did it.. I use take() and skip() to read from my datatable and bind it to chart.
Have a nice day :)

JoCodes 28-Jan-14 23:32pm

Very Glad to hear that. Have a Great day. :)