creating line charts on the basis of cells selections

[gulshan-escalon]

Hi Paul,

Hope you are doing good !!!

Actually I want to create line charts on the basis of cells selections. Is there any idea from your end as I am using jexcel plugin.

Thanks
Gulshan

[pphod]

This is an example how to create a chart based on the full spreadsheet.
http://www.bossanova.uk/jexcel/tracking-changes-on-the-spreadsheet
http://jsfiddle.net/zmtsbnng/

To can adapt the script to use only the selected cells, you can get all selected by using:
var td = $('#your-table-id').find('.highlight');

If you have problems on doing that, you can share your try on fiddle and I can suggest solutions.

Regards

[gulshan-escalon]

Thanks for your feedback But I need little bit different than you sent me. I have to manually select the rows or columns for x-axis and y-axis. For that I took input fields for selection. In first input fields i do selects cells for x-axis and in another input fields I again do select for y -axis then On the basis of both selection I have to make the data for x-axis and y-axis.

Any solution for that ?

Thanks

[pphod]

Hi, to get the selected data as a JS array:

var data = $('#yourtable').jexcel('getData', true); // True get only the selected cells data
console.log(data);

[gulshan-escalon]

Hi , Thanks working on the same , Now I want to make the x-axis label dynemic on the basis of selection into excell sheet . Any solution form me would be apreciated. ??

[pphod]

You have two methods to get information from jExcel.
$('#yourtable').jexcel('getData', true); // Get all selected data in an array
$('#yourtable').jexcel('getValue', 'B1'); // Get value from one specified cell A1, B2, C39, etc...

[gulshan-escalon]

yes , But How can i change the label into line charts according to the cells selection value. currently its ['jan','feb', ...so on] But I want to change it by the selection value , Any Idea ?

[gulshan-escalon]

I am getting the value from excell Now I need to reflect it to the line charts. Like If I choose three value for x-axis from excell sheet now I want those value as label of x-axis. What I am doing I made the restriction for the user to choose one column or one row at a time so I want those value in the x-axis and y-axis in the line charts. How can i achieve this ?

[pphod]

Hi,
Well you can easily extract the information from the table, but now you should applied that to meet your requirements. All the best

[gulshan-escalon]

ok , Thanks Paul

[Harsh-baghel]

Hi Paul,

How can i get the particular row data corresponding to the header using jexcel v3 plugin.
Like my header are company name, website,email so i want data like this company name-Ideapoke Technology, website- www.ideapoke.com , email- info@ideapoke.com in the json format.
Is there any way to get data like this please suggest me any idea related to my query.

Thanks in advance