ASE Home Page Products Download Purchase Support About ASE
ChartDirector Support
 Forum HomeForum Home   SearchSearch

Message ListMessage List     Post MessagePost Message

  Creating Bar chart using HTML data
Posted by ram on Apr-05-2016 04:35
| Reply | Monitor
Attachments:
I have table data with values attaching the screen shot and i would like use 2 column as my X axis labels and 3 columns values are ones used for build bar chart in descendung order.

How to get exactly 2 column for x  axis label and 3 column for chart data .


Please give suggestion to achieve this.


Thanks,
Ram
Tabledat.PNG

  Re: Creating Bar chart using HTML data
Posted by Peter Kwan on Apr-05-2016 13:20
| Reply | Monitor
Hi ram,

Sorry, I am not sure the type of chart you would like to create. In your table, I can see 3 text labels "Server 1", "Server 2" and "Server 3", and I can see 12 values. Do you mean you would like to create a bar chart with 12 bars using the 12 values? You mentioned the bars should be in descending order. Do you mean you want to the sort the 12 values so that they are in descending order? Or do you mean you want to separate the bars into 3 groups for "Server 1", "Server 2" and "Server 3" (like a "Multi-Bar Chart"), with each group having 4 bars, and with the 4 bars sorted within each group (which is different from sorting 12 bars all together)? Or do you mean you want to separate the bars into 4 groups, which each group having 3 bars, and the 3 bars sorted within each group. As there are only 3 labels in the table, I am not sure what you mean by "use 2 column as my X axis labels". Is it possible to attach an example chart image to help me understand your requirements?

Regards
Peter Kwan

  Re: Creating Bar chart using HTML data
Posted by ram on Apr-11-2016 19:42
| Reply | Monitor
Attachments:
I have re-pharsed req now.

I need to take value from S1 column and used it X-axis label [eg 1990,1991.Attached Graph sample for that] and S2 column values for Bar graph .

Attaching the sample Graph.

I need to know how to fetch the html data into array of the both the columns to plot the bar graph.

Hope i have given the my requirement properly now and looking for your support.

Thank you .
Samplegraphntabledata.PNG

  Re: Creating Bar chart using HTML data
Posted by Peter Kwan on Apr-12-2016 01:54
| Reply | Monitor
Hi ram,

For "HTML data", my impression is that HTML is just a method to display the data. The data probably come from somewhere else, such as from a database. That means you have some code that reads the data from the database and output the HTML table. Please modify the code to use the same data to create arrays. In particular, your code can use the values in S1 to create the labels array, and the values in S2 to create the data array.

If you need further help, would you mind to provide the code you are using that can create the HTML table? This part of the code should be unrelated to the chart, but can help me understand how you obtain the data. We can start from your code and modify it to create arrays instead, and use the arrays to draw the chart.

Regards
Peter Kwan