Jump to content
Android Forum - A Community For Android Users and Enthusiasts

Android pie chart and sqlite


Recommended Posts



when working with charts, android have  a lot pluggins of charts like achartengine, etc.  currently i am using pie chart in my app but i dont have any idea to work with sqlite in charts. Anyone had a  demo that use sqlite?  this is a demo:

package in.wptrafficanalyzer.achartenginepiechart;

import org.achartengine.ChartFactory;
import org.achartengine.GraphicalView;
import org.achartengine.model.CategorySeries;
import org.achartengine.renderer.DefaultRenderer;
import org.achartengine.renderer.SimpleSeriesRenderer;

import android.app.Activity;
import android.content.Intent;
import android.graphics.Color;
import android.os.Bundle;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;

public class MainActivity extends Activity {
	private String[] mMonth = new String[] {
				"Jan", "Feb" , "Mar", "Apr", "May", "Jun",
				"Jul", "Aug" , "Sep", "Oct", "Nov", "Dec"

    public void onCreate(Bundle savedInstanceState) {
        // Getting reference to the button btn_chart
        Button btnChart = (Button) findViewById(R.id.btn_chart);
        // Defining click event listener for the button btn_chart
        OnClickListener clickListener = new OnClickListener() {
			public void onClick(View v) {
				// Draw the Income vs Expense Chart
		// Setting event click listener for the button btn_chart of the MainActivity layout
    private void openChart(){    	
    	// Pie Chart Section Names
    	String[] code = new String[] {
    			"Eclair & Older", "Froyo", "Gingerbread", "Honeycomb",
    			"IceCream Sandwich", "Jelly Bean" 
    	// Pie Chart Section Value
    	double[] distribution = { 3.9, 12.9, 55.8, 1.9, 23.7, 1.8 } ;
    	// Color of each Pie Chart Sections
    	int[] colors = { Color.BLUE, Color.MAGENTA, Color.GREEN, Color.CYAN, Color.RED,
    					 Color.YELLOW };
    	// Instantiating CategorySeries to plot Pie Chart    	
    	CategorySeries distributionSeries = new CategorySeries(" Android version distribution as on October 1, 2012");
    	for(int i=0 ;i < distribution.length;i++){
    		// Adding a slice with its values and name to the Pie Chart
    		distributionSeries.add(code[i], distribution[i]);
    	// Instantiating a renderer for the Pie Chart
    	DefaultRenderer defaultRenderer  = new DefaultRenderer();    	
    	for(int i = 0 ;i<distribution.length;i++){    		
    		SimpleSeriesRenderer seriesRenderer = new SimpleSeriesRenderer();    	
    		// Adding a renderer for a slice
    	defaultRenderer.setChartTitle("Android version distribution as on October 1, 2012 ");
    	// Creating an intent to plot bar chart using dataset and multipleRenderer    	
    	Intent intent = ChartFactory.getPieChartIntent(getBaseContext(), distributionSeries , defaultRenderer, "AChartEnginePieChartDemo");    	
    	// Start Activity

    public boolean onCreateOptionsMenu(Menu menu) {
        getMenuInflater().inflate(R.menu.activity_main, menu);
        return true;

how to replace this arrays String[] code = new String[] and double[] distribution = { 3.9, 12.9, 55.8, 1.9, 23.7, 1.8 } ; with sqlite?


Link to comment
Share on other sites

  • 1 month later...

Hi Newbie, the main question is:

Have you got a sqlite database with a table that contains the data you want to see in the pie chart?

If so, you can read the data from the cursor and create appropriate arrays.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...