Android Question Creating a bar chart using data from files.

[Izmirov.Yaminovich]

Hi,

Anybody knows how to create a bar chart that can link to the sets of data's that I have in the csv files?

Something like this

Thanks

 

[Lahksman]

I use Johan Schoemans library for my charts.

 

[Izmirov.Yaminovich]

Creating a chart is not the problem. The problem is to retrieve the datas from the csv file to make a bar chart. say I have a sets of datas in a csv files like this:

And I would like to plot a bar chart using data's from the files. Do you know how can I do it?

 

[Erel]

You can use StringUtils.LoadCSV to read CSV files.

 

[Izmirov.Yaminovich]

Hi Erel, how do I link the datas from the file?

Private Sub CreateBarChartData (cols As List, rows As List)
    cols.Add(CreateColumn("", "Location", "string"))
    cols.Add(CreateColumn("", "Volume", "number"))
    cols.Add(CreateColumn("", "Expenses", "number"))
    rows.Add(CreateRow(Array As Object("1", 34, 40)))
    rows.Add(CreateRow(Array As Object("2", 17, 46)))
End Sub

Instead of keying it in the code, are there anyway to just link it up from the files? For example, the value in A1 in the file is 34, what should I write to just makes it automatically links it instead of keying in 34?

 

[DonManfred]

to just makes it automatically links it instead of keying in 34

There is no automatic way. It is YOUR job to build the code.

 

[Izmirov.Yaminovich]

Yes, when I say automatic it means that's the function of that the code should do. Do you know the code or link I can read about?

 

[DonManfred]

Do you know the code or link I can read about?

No. Learn the language and code it yourself

 

[mangojack]

Yes, when I say automatic it means that's the function of that the code should do. Do you know the code or link I can read about?

Read thru this thread ...https://www.b4x.com/android/forum/threads/csv-contain-names-of-variables.63604/#content

Although it has no connection to creating charts ... If you study it , It will demonstrate how to read your csv file to a list , then iterate thru that list to retrieve your data.
You can then reference that data in your chart statements instead of manually typing in the data.

 

[mangojack]

Here is another interesting one to study .. https://www.b4x.com/android/forum/t...rrays-when-working-with-csv.16448/#post-93680

 

[Peter Simpson]

Here @Izmirov.Yaminovich, look at the code in Google Charts and adapt the code for yourself https://www.b4x.com/android/forum/threads/add-charts-with-google-charts-service.39197/#content

 

[Izmirov.Yaminovich]

For the google charts, I realized that there's a need to copy down the template.html into the files folder. The codes in the files are as below:

<html>
  <head>
    <script type="text/javascript" src="https://www.google.com/jsapi"></script>
    <script type="text/javascript">
      google.load("visualization", "1", {packages:["corechart"]});
      google.setOnLoadCallback(drawChart);
      function drawChart() {
        var data = new google.visualization.DataTable($DATA$);

        var options = $OPTIONS$

        var chart = new google.visualization.$TYPE$(document.getElementById('chart'));
        chart.draw(data, options);
      }
    </script>
  </head>
  <body>
    <div id="chart" style="width: 100%; height: 100%;"></div>
  </body>
</html>

Is it possible for me to change the HTML code in there that can allow me to link it to the data's that I have?