To make reading of this page more valuable (for future search results) I made a list of libraries known to me.. As @CommonsWare mentioned there are super-similar questions/answers.. Anyway some libraries that can be used for making charts are:

Open Source:

 - [AnyChart][23] (Free for non-commercial, Paid for commercial)
 - [MPAndroidChart][1]
 - [Holo Graph Library][2]
 - [aChartEngine][21]
 - [ChartView][4]
 - [aFreeChart][5]
 - [ChartDroid][6]
 - [charts4j][7]
 - [GraphView][8]
 - [AndroidPlot][9]
 - [Drawing the 3D piechart Using Google chart Api][10]
 - [WilliamChart][11]
 - [HelloCharts][12]
 - [ChartProgressBar][13]
 - [Plot.ly][22]

Paid:

 - [aiCharts][14] 
 - [RChart][15] (pre Honeycomb - Api 11 UI)
 - [ShinobiControls][16] **
 - [Steema TeeChart][17] **
 - [Orson Charts][18] (3D charts for Android)
 - [Telerik Rad Chart][19]
 - [SciChart][20] (Realtime Charts for Android)

** - means I didn&#39;t try those so I can&#39;t really recommend it but other users suggested it.. 


  [1]: https://github.com/PhilJay/MPAndroidChart
  [2]: https://bitbucket.org/danielnadeau/holographlibrary/wiki/Home
  [3]: http://www.achartengine.org/content/demo.html
  [4]: https://github.com/brandhill/ChartView
  [5]: https://github.com/johnjohndoe/AFreeChart
  [6]: https://github.com/kostmo/chartdroid
  [7]: https://github.com/julienchastang/charts4j
  [8]: http://android.arnodenhond.com/components/graphview
  [9]: https://bitbucket.org/androidplot/androidplot/src
  [10]: http://androidtutorials60.blogspot.in/2013/06/drawing-3d-piechart-using-google-chart.html
  [11]: https://github.com/diogobernardino/WilliamChart
  [12]: https://github.com/lecho/hellocharts-android
  [13]: https://github.com/hadiidbouk/ChartProgressBar
  [14]: http://www.artfulbits.com/products/android/aiCharts.aspx
  [15]: http://www.java4less.com/charts/chart.php?info=android
  [16]: http://www.shinobicontrols.com/android/shinobicharts/product-tour/
  [17]: https://play.google.com/store/apps/details?id=com.steema.teechart.android&amp;hl=en
  [18]: http://www.object-refinery.com/orsoncharts/android/index.html
  [19]: http://www.telerik.com/android-ui/chart
  [20]: http://www.scichart.com/android-chart-features
  [21]: https://github.com/ddanny/achartengine
  [22]: http://www.plot.ly
  [23]: https://github.com/AnyChart/AnyChart-Android

[SciChart for Android][1] is a relative newcomer, but brings extremely fast high performance real-time charting to the Android platform. 

SciChart is a commercial control but available under royalty free distribution / per developer licensing. There is also [free licensing available][7] for educational use with some conditions.   

Some useful links can be found below:

 - SciChart&#39;s [Android Charts Features][1]
 - [Android Chart Performance Tests][2] vs. Open Source &amp; Commercial 
 - [Android Chart Examples][3] and example source code
 - [SciChart Quick Start Guide][4]
 - [Android Charts Documentation][5]

[![enter image description here][6]][6]

*Disclosure: I am the tech lead on the SciChart project!*


  [1]: http://www.scichart.com/android-chart-features
  [2]: http://www.scichart.com/android-chart-performance-comparison/
  [3]: http://www.scichart.com/android-chart-examples
  [4]: http://www.scichart.com/getting-started-scichart-android/
  [5]: http://www.scichart.com/documentation/android/v1.x/SciChart_Android_v1_SDK_User_Manual.html
  [6]: http://i.stack.imgur.com/r36TU.png
  [7]: http://www.scichart.com/educational-discount-programme/

In addition to the src/main/java, I am adding a src/bootstrap directory that I want to include in my build process, in other words, I want maven to compile and include the sources there in my build. How!?

How to add an extra source directory for maven to compile and include in the build jar?

I have narrowed my problem down to being a problem with the FragmentManager retaining instances of old fragments and my viewpager being out of sync with my FragmentManager. See this issue: http://code.google.com/p/android/issues/detail?id=19211#makechanges. I still have no clue how to solve this. Any suggestions?

I have tried to debug this for a long time and any help would be greatly appreciated. I am using a FragmentPagerAdapter which accepts a list of fragments like so:
   
    List&lt;Fragment&gt; fragments = new Vector&lt;Fragment&gt;();
    fragments.add(Fragment.instantiate(this, Fragment1.class.getName())); 
    ...
    new PagerAdapter(getSupportFragmentManager(), fragments);

The implementation is standard. I am using ActionBarSherlock and v4 computability library for Fragments.

My problem is that after leaving the app and opening several other applications and coming back, the fragments lose their reference back to the FragmentActivity (ie. `getActivity() == null`). I can not figure out why this is happening. I tried to manually set `setRetainInstance(true);` but this does not help. I figured that this happens when my FragmentActivity gets destroyed, however this still happens if I open the app before I get the log message. Are there any ideas?

    @Override
	protected void onDestroy(){
		Log.w(TAG, &quot;DESTROYDESTROYDESTROYDESTROYDESTROYDESTROYDESTROY&quot;);
		super.onDestroy();
	}

The adapter:

    public class PagerAdapter extends FragmentPagerAdapter {
		private List&lt;Fragment&gt; fragments;

		public PagerAdapter(FragmentManager fm, List&lt;Fragment&gt; fragments) {
			super(fm);

			this.fragments = fragments;

		}

		@Override
		public Fragment getItem(int position) {

			return this.fragments.get(position);

		}

		@Override
		public int getCount() {

			return this.fragments.size();

		}

	}

One of my Fragments stripped but I commented everything out that&#39;s stripped and it still doesn&#39;t work.
 
    
    public class MyFragment extends Fragment implements MyFragmentInterface, OnScrollListener {
	...
	
	@Override
	public void onCreate(Bundle savedInstanceState){
		super.onCreate(savedInstanceState);
	    handler = new Handler();	
		setHasOptionsMenu(true);
	}
	
	@Override
    public void onAttach(Activity activity) {
        super.onAttach(activity);
        Log.w(TAG,&quot;ATTACHATTACHATTACHATTACHATTACH&quot;);
        context = activity;
        if(context== null){
			Log.e(&quot;IS NULL&quot;, &quot;NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL&quot;);
		}else{
			Log.d(&quot;IS NOT NULL&quot;, &quot;NOTNOTNOTNOTNOTNOTNOTNOT&quot;);
		}

    }
	
	@Override
	public void onActivityCreated(Bundle savedState) {
		super.onActivityCreated(savedState);
	}

	@Override
    public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
    	View v = inflater.inflate(R.layout.my_fragment,container, false);

    	return v;
    }
	
	
	@Override
	public void onResume(){
		super.onResume();
	}
	
	private void callService(){
		// do not call another service is already running
		if(startLoad || !canSet) return;
		// set flag
		startLoad = true;
		canSet = false;
		// show the bottom spinner
		addFooter();
		Intent intent = new Intent(context, MyService.class);
		intent.putExtra(MyService.STATUS_RECEIVER, resultReceiver);
		context.startService(intent);
	}
	
	private ResultReceiver resultReceiver = new ResultReceiver(null) {
        @Override
        protected void onReceiveResult(int resultCode, final Bundle resultData) {
        	boolean isSet = false;
        	if(resultData!=null)
        	if(resultData.containsKey(MyService.STATUS_FINISHED_GET)){
        		if(resultData.getBoolean(MyService.STATUS_FINISHED_GET)){
        			removeFooter();
        			startLoad = false;
        			isSet = true;
        		}
        	}

        	switch(resultCode){
        	case MyService.STATUS_FINISHED: 
        		stopSpinning();
        		break;
        	case SyncService.STATUS_RUNNING:
        		break;
        	case SyncService.STATUS_ERROR:
        		break;
        	}
        }
    };
    
	public void onCreateOptionsMenu(Menu menu, MenuInflater inflater) {
		menu.clear();
		inflater.inflate(R.menu.activity, menu);
    }
	
	@Override
	public void onPause(){
		super.onPause();
	}
	
	public void onScroll(AbsListView arg0, int firstVisible, int visibleCount, int totalCount) {
        boolean loadMore = /* maybe add a padding */
            firstVisible + visibleCount &gt;= totalCount;
            
        boolean away = firstVisible+ visibleCount &lt;= totalCount - visibleCount;
            
        if(away){
        	// startLoad can now be set again
        	canSet = true;
        }
            
        if(loadMore) 
        	
	}
	
	public void onScrollStateChanged(AbsListView arg0, int state) {
		switch(state){
		case OnScrollListener.SCROLL_STATE_FLING: 
			adapter.setLoad(false); 
			lastState = OnScrollListener.SCROLL_STATE_FLING;
			break;
		case OnScrollListener.SCROLL_STATE_IDLE: 
			adapter.setLoad(true);
			if(lastState == SCROLL_STATE_FLING){
				// load the images on screen
			}
			
			lastState = OnScrollListener.SCROLL_STATE_IDLE;
			break;
		case OnScrollListener.SCROLL_STATE_TOUCH_SCROLL:
			adapter.setLoad(true);
			if(lastState == SCROLL_STATE_FLING){
				// load the images on screen
			}
			
			lastState = OnScrollListener.SCROLL_STATE_TOUCH_SCROLL;
			break;
		}
	}
	
	@Override
	public void onDetach(){
		super.onDetach();
		if(this.adapter!=null)
			this.adapter.clearContext();
		
		Log.w(TAG, &quot;DETACHEDDETACHEDDETACHEDDETACHEDDETACHEDDETACHED&quot;);
	}
	
	public void update(final int id, String name) {
		if(name!=null){
			getActivity().getSupportActionBar().setTitle(name);
		}
		
	}
}

The update method is called when a user interacts with a different fragment and the getActivity is returning null. Here is the method the other fragment is calling:

    ((MyFragment) pagerAdapter.getItem(1)).update(id, name);

I believe that when the app is destroyed then created again instead of just starting the app up to the default fragment the app starts up and then viewpager navigates to the last known page. This seems strange, shouldn&#39;t the app just load to the default fragment? 

support FragmentPagerAdapter holds reference to old fragments

I am working on a project which have some charts (graphs), tick chart, candlestick chart and range chart. But the problem is, there is no library for that charts. I have got Google chart API for candlestick chart. But I don&#39;t want graph/chart in a webview.

Example: [Android Candlestick Chart with Google Chart API][1]

  [1]: http://rpiesnikowski.blogspot.in/2011/03/android-candlestick-chart-with-google.html

Charts for Android

<p>I am working on a project which have some charts (graphs), tick chart, candlestick chart and range chart. But the problem is, there is no library for that charts. I have got Google chart API for candlestick chart. But I don't want graph/chart in a webview.</p>
<p>Example: <a href="http://rpiesnikowski.blogspot.in/2011/03/android-candlestick-chart-with-google.html" target="_blank" rel="noopener noreferrer">Android Candlestick Chart with Google Chart API</a></p>


Just started to use Robolectric and it seems to be pretty much what I need. However, I&#39;ve hit a bit of a roadblock with regards to the use of SharedPreferences.

I have two tests cases

 1. Activity expects a new/empty sharedPreferences  

 1. Activity expects sharedPreferences with some data in it already

For Test Case 1, the tests are passing as expected, so all good :)

However, for Test Case 2 I can&#39;t seem to figure out a nice way to provide Robolectric with some fake data, so the Activity is able to access this fake data.

It feels like a very common use case, but I can&#39;t seem to figure out how to do it!

Providing test data for SharedPreferences for Robolectric

Android&#39;s TextView class can display formatted text via HTML.fromHtml() as explained for example here: https://stackoverflow.com/questions/4546009/html-tags-in-string-for-textview

The TextView class can only deal with a small subset of HTML, but I do not know which tags and attributes are supported and which are not. The summary given here: http://commonsware.com/blog/Android/2010/05/26/html-tags-supported-by-textview.html does not seem to be correct. E.g. &amp;lt;div align=&amp;quot;...&amp;quot;&amp;gt; does NOT work for me using Android 2.2



Which HTML tags are supported by Android TextView?

Currently when the user opens my app, an `AlertDialog` opens, asking them if they would like to upgrade to the pro version.

I need to add a `CheckBox` to the `AlertDialog` that will make the app no longer show the `AlertDialog` when the user opens the app.

Here is what I have for the `AlertDialog` now:

    AlertDialog.Builder builder = new AlertDialog.Builder(this);
        builder.setTitle(&quot; MY_TEXT&quot;);
        builder.setMessage(&quot; MY_TEXT &quot;)
               .setCancelable(false)
               .setPositiveButton(&quot;Yes&quot;, new DialogInterface.OnClickListener() {
                   public void onClick(DialogInterface dialog, int id) {
                       Uri uri = Uri.parse(&quot;market://details?id=MY_APP_PACKAGE&quot;);
                       Intent intent = new Intent (Intent.ACTION_VIEW, uri);
                       startActivity(intent);                          }
               })
               .setNegativeButton(&quot;No&quot;, new DialogInterface.OnClickListener() {
                   public void onClick(DialogInterface dialog, int id) {
                        dialog.cancel();
                   }
               }).show();

How do I add a `CheckBox` to the `AlertDialog` that will make the app no longer show the `AlertDialog` when the user opens the app?




How to add a check box to an alert dialog

I have been looking for a way to get rid of the nasty black initial screen on a VideoView before the `start()` method is run.

I have tried with background image on the widget but it doesn&#39;t work as expected at all.
I have also tried putting an image of the first frame in the video on top of the VideoView and hiding it after the `start()` method.
Adding an onPrepared listener to start the video and then hide the image. This works but there is a horrible flicker in the transition and I don&#39;t know how to get rid of it.

---

Adding the MediaController had no effect at all. The problem persists (I still see the black flicker) and I don&#39;t want to have the video controls visible at all. 
My code looks like this: 


        VideoView vSurface= (VideoView) findViewById(R.id.surfaceView1);
        vSurface.setVideoURI(Uri.parse(&quot;android.resource://com.mypackage/&quot; + R.raw.video1));
        vSurface.setVisibility(View.VISIBLE);
        vSurface.setOnPreparedListener(this);
        vSurface.setDrawingCacheEnabled(true);
        vSurface.setOnErrorListener(this);

Android VideoView black screen

I am trying to do **POST** with `HttpURLConnection`(I need to use it this way, can&#39;t use `HttpPost`) and I&#39;d like to add parameters to that connection such as

    post.setEntity(new UrlEncodedFormEntity(nvp));

where

    nvp = new ArrayList&lt;NameValuePair&gt;();

having some data stored in. I can&#39;t find a way how to add this `ArrayList` to my `HttpURLConnection` which is here:

    HttpsURLConnection https = (HttpsURLConnection) url.openConnection();
    https.setHostnameVerifier(DO_NOT_VERIFY);
    http = https;
    http.setRequestMethod(&quot;POST&quot;);
    http.setDoInput(true);
    http.setDoOutput(true);

The reason for that awkward https and http combination is the need for *not verifying* the certificate. That is not a problem, though, it posts the server well. But I need it to post with arguments. 

Any ideas?

---
**Duplicate Disclaimer:**

Back in 2012, I had no idea how parameters were inserted into an **HTTP POST** request. I was hanging on to `NameValuePair` because it was in a tutorial. This question might seem like a duplicate, however, my 2012 self read that *[other][1]* question and it was **NOT** using `NameValuePair`. It did not, in fact, solve my problem.


  [1]: https://stackoverflow.com/questions/4205980/java-sending-http-parameters-via-post-method-easily

How to add parameters to HttpURLConnection using POST using NameValuePair

I am trying to get the x axis labels to be rotated 45 degrees on a barplot with no luck. This is the code I have below:

    barplot(((data1[,1] - average)/average) * 100,
            srt       = 45,
            adj       = 1,
            xpd       = TRUE,
            names.arg = data1[,2],
            col       = c(&quot;#3CA0D0&quot;),
            main      = &quot;Best Lift Time to Vertical Drop Ratios of North American Resorts&quot;,
            ylab      = &quot;Normalized Difference&quot;,
            yaxt      = &#39;n&#39;,
            cex.names = 0.65,
            cex.lab   = 0.65)



Rotating x axis labels in R for barplot

This is a follow-up question of https://stackoverflow.com/questions/10381474/graph-why-most-graph-algorithms-do-not-adapt-so-easily-to-negative-numbers.

I think Shortest Path (SP) has problem with negative weights, because it adds up all weights along the paths and tries to find the minimum one.

But I don&#39;t think Minimum Spanning Tree (MST) has problems with negative weights, because it just takes the single minimum weight edge without caring about the overall total weights.

Am I right?

Is Minimum Spanning Tree afraid of negative weights?

I have a list of dates, each date in it can occur more than once. I want to count the number of times each date occurs (histogram) and display it in a graph (with the Y axis being the number of times the date occurs and the X axis being the date itself)?

Sample list:

    19/05/2012
    19/05/2012
    19/05/2012
    17/05/2012
    17/05/2012
    16/05/2012
    16/05/2012
    16/05/2012
    16/05/2012
    15/05/2012
    15/05/2012
    15/05/2012
    15/05/2012
    12/05/2012
    12/05/2012
    12/05/2012
    7/05/2012

I clicked every menu option over the past few years and never did I find anything specific to this. Would this be a case for using PivotTables somehow?

Count number of times a date occurs and make a graph out of it

So i have a page already which draws a force directed graph, like the one shown [here][1].

And that works fine. I&#39;m using the JS from [here][2], with a few tweaks to spread out the nodes slightly nicer.

These are more or less the only differences:

    d3.json(&quot;force.json&quot;, function(json) {
      var force = d3.layout.force()
          .gravity(0.1)
          .charge(-2000)
          .linkDistance(1)
          .linkStrength(0.1)
          .nodes(json.nodes)
          .links(json.links)
          .size([w, h])
          .start();

Where reducing the link strength seems to make the links more like springs, so it becomes similar to the [Fruchterman &amp; Reingold][3] technique often used. This works reasonably well, but only for fairly small graphs. With larger graphs the number of crossings just goes up - as one would expect, but the solution it lands on is normally far from optimal. I&#39;m not looking for a method to get the optimal solution, I know that&#39;s very difficult. I would just like it to have some crude addition that tries to force the lines apart as well as the nodes.

**Is there a way to add a repulsion between in links, as well as between the nodes?** I&#39;m not familiar with the way D3 force works, and i can&#39;t seem to find anything that says this is possible...


  [1]: http://networkx.lanl.gov/
  [2]: http://mbostock.github.com/d3/ex/force.html
  [3]: http://en.wikipedia.org/wiki/Force-based_algorithms_%28graph_drawing%29

D3.js force directed graph, reduce edge crossings by making edges repel each other

I need a working algorithm for finding all simple cycles in an undirected graph. I know the cost can be exponential and the problem is NP-complete, but I am going to use it in a small graph (up to 20-30 vertices) and the cycles are small in number.

After a long research (mainly here) I still don&#39;t have a working approach. Here is a summary of my search:

https://stackoverflow.com/questions/5068086/finding-all-cycles-in-an-undirected-graph

https://stackoverflow.com/questions/526331/cycles-in-an-undirected-graph -&gt; detects only whether there is a cycle or not

https://stackoverflow.com/questions/9804127/finding-polygons-within-an-undirected-graph -&gt; very nice description, but no solution

https://stackoverflow.com/questions/546655/finding-all-cycles-in-graph/549402#549402 -&gt; finds cycles only in directed graphs

https://stackoverflow.com/questions/9626249/detect-cycles-in-undirected-graph-using-boost-graph-library

The only answer I found, which approaches my problem, is this one:

https://stackoverflow.com/questions/2839908/find-all-cycles-in-graph-redux

It seems that finding a basic set of cycles and XOR-ing them could do the trick. Finding a basic set of cycles is easy, but I don&#39;t understand how to combine them in order to obtain all cycles in the graph...

Finding all cycles in undirected graphs

What I&#39;ve done
=============

I&#39;ve added Google chart to the head of my page. This returns an image of a chart.

What I need to do
=================

I simply need to add a second chart to the same page.

The problem
===========

The code for the second chart is ignored. I largely suspect this is due to me incorrectly combining the code for each chart.

The code
========

**First chart (line):**

        &lt;!--Load the AJAX API--&gt;
    &lt;script type=&quot;text/javascript&quot; src=&quot;https://www.google.com/jsapi&quot;&gt;&lt;/script&gt;
    &lt;script type=&quot;text/javascript&quot;&gt;

      // Load the Visualization API and the piechart package.
      google.load(&#39;visualization&#39;, &#39;1.0&#39;, {&#39;packages&#39;:[&#39;corechart&#39;]});

      // Set a callback to run when the Google Visualization API is loaded.
      google.setOnLoadCallback(drawChart);

      // Callback that creates and populates a data table,
      // instantiates the pie chart, passes in the data and
      // draws it.
      function drawChart() {

        var data = new google.visualization.DataTable();
        data.addColumn(&#39;string&#39;, &#39;Month&#39;);
        data.addColumn(&#39;number&#39;, &#39;Apples&#39;);
        data.addColumn(&#39;number&#39;, &#39;Oranges&#39;);
        data.addRows([
          [&#39;Oct 11&#39;, 20, 0],
          [&#39;Nov 11&#39;, 0, 0],
          [&#39;Dec 12&#39;,  0, 20],
          [&#39;Jan 12&#39;, 0, 10],
          [&#39;Feb 12&#39;, 0, 10],
          [&#39;March 12&#39;, 10, 10]
        ]);

        // Set chart options
        var options = {&#39;width&#39;:960,
                       &#39;height&#39;:300};

        // Instantiate and draw our chart, passing in some options.
        var chart = new google.visualization.LineChart(document.getElementById(&#39;line_chart&#39;));
        chart.draw(data, options);
      }

    &lt;/script&gt;

**Second chart (pie):**

        &lt;!--Load the AJAX API--&gt;
    &lt;script type=&quot;text/javascript&quot; src=&quot;https://www.google.com/jsapi&quot;&gt;&lt;/script&gt;
    &lt;script type=&quot;text/javascript&quot;&gt;

      // Load the Visualization API and the piechart package.
      google.load(&#39;visualization&#39;, &#39;1.0&#39;, {&#39;packages&#39;:[&#39;corechart&#39;]});

      // Set a callback to run when the Google Visualization API is loaded.
      google.setOnLoadCallback(drawChart);

      // Callback that creates and populates a data table,
      // instantiates the pie chart, passes in the data and
      // draws it.
      function drawChart() {

        // Create the data table.
        var data = new google.visualization.DataTable();
        data.addColumn(&#39;string&#39;, &#39;Topping&#39;);
        data.addColumn(&#39;number&#39;, &#39;Slices&#39;);
        data.addRows([
          [&#39;Mushrooms&#39;, 3],
          [&#39;Onions&#39;, 1],
          [&#39;Olives&#39;, 1],
          [&#39;Zucchini&#39;, 1],
          [&#39;Pepperoni&#39;, 2]
        ]);

        // Set chart options
        var options = {&#39;title&#39;:&#39;How Much Pizza I Ate Last Night&#39;,
                       &#39;width&#39;:400,
                       &#39;height&#39;:300};

        // Instantiate and draw our chart, passing in some options.
        var chart = new google.visualization.PieChart(document.getElementById(&#39;chart_div&#39;));
        chart.draw(data, options);
      }
    &lt;/script&gt;

Each of the charts are called in the body using a container div with a unique id:

    &lt;div id=&quot;chart_div&quot;&gt;&lt;/div&gt;

My question
===========

How do I stitch these two blocks of code together? I&#39;ve tried copying drawChart() and specifying unique function names and variables but to no avail.


How to add two Google charts on the one page?

I am trying to hide the axis and gridlines of my Highcharts chart entirely.
So far I have tried to set the width of the lines to 0, but it didn&#39;t work out.

    
    xAxis: {
      lineWidth: 0,
      minorGridLineWidth: 0,
      lineColor: &#39;transparent&#39;
    }

Is it possible to just globally disable the axis lines/ticks and gridlines to create a &quot;plain&quot; plot?

Hide axis and gridlines Highcharts

I have searched a lot to find a good example for generating a Google Chart using MySQL table data as the data source. I searched for a couple of days and realised that there are few examples available for generating a Google Chart (pie, bar, column, table) using a combination of PHP and MySQL. I finally managed to get one example working.

I have previously received a lot of help from StackOverflow, so this time I will return some.

I have two examples; one uses Ajax and the other does not. Today, I will only show the non-Ajax example.

**Usage:**
&lt;pre&gt;
    Requirements: PHP, Apache and MySQL
    
    Installation:
    
      --- Create a database by using phpMyAdmin and name it &quot;chart&quot;
      --- Create a table by using phpMyAdmin and name it &quot;googlechart&quot; and make 
          sure table has only two columns as I have used two columns. However, 
          you can use more than 2 columns if you like but you have to change the 
          code a little bit for that
      --- Specify column names as follows: &quot;weekly_task&quot; and &quot;percentage&quot;
      --- Insert some data into the table
      --- For the percentage column only use a number
    
          ---------------------------------
          example data: Table (googlechart)
          ---------------------------------
    
          weekly_task     percentage
          -----------     ----------
          Sleep           30
          Watching Movie  10
          job             40
          Exercise        20    
 
&lt;/pre&gt;

&lt;br/&gt;

**PHP-MySQL-JSON-Google Chart  Example:** 

        &lt;?php
    $con=mysql_connect(&quot;localhost&quot;,&quot;Username&quot;,&quot;Password&quot;) or die(&quot;Failed to connect with database!!!!&quot;);
    mysql_select_db(&quot;Database Name&quot;, $con); 
    // The Chart table contains two fields: weekly_task and percentage
    // This example will display a pie chart. If you need other charts such as a Bar chart, you will need to modify the code a little to make it work with bar chart and other charts
    $sth = mysql_query(&quot;SELECT * FROM chart&quot;);
    
    /*
    ---------------------------
    example data: Table (Chart)
    --------------------------
    weekly_task		percentage
    Sleep			30
    Watching Movie	40
    work			44
    */

    //flag is not needed
    $flag = true;
    $table = array();
    $table[&#39;cols&#39;] = array(
        
    	// Labels for your chart, these represent the column titles
    	// Note that one column is in &quot;string&quot; format and another one is in &quot;number&quot; format as pie chart only required &quot;numbers&quot; for calculating percentage and string will be used for column title
    	array(&#39;label&#39; =&gt; &#39;Weekly Task&#39;, &#39;type&#39; =&gt; &#39;string&#39;),
    	array(&#39;label&#39; =&gt; &#39;Percentage&#39;, &#39;type&#39; =&gt; &#39;number&#39;)
    	
    );
    
    $rows = array();
    while($r = mysql_fetch_assoc($sth)) {
        $temp = array();
    	// the following line will be used to slice the Pie chart
    	$temp[] = array(&#39;v&#39; =&gt; (string) $r[&#39;Weekly_task&#39;]); 
    	
    	// Values of each slice
    	$temp[] = array(&#39;v&#39; =&gt; (int) $r[&#39;percentage&#39;]); 
    	$rows[] = array(&#39;c&#39; =&gt; $temp);
    }
    
    $table[&#39;rows&#39;] = $rows;
    $jsonTable = json_encode($table);
    //echo $jsonTable;
    ?&gt;

    &lt;html&gt;
      &lt;head&gt;
        &lt;!--Load the Ajax API--&gt;
        &lt;script type=&quot;text/javascript&quot; src=&quot;https://www.google.com/jsapi&quot;&gt;&lt;/script&gt;
        &lt;script type=&quot;text/javascript&quot; src=&quot;http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js&quot;&gt;&lt;/script&gt;
        &lt;script type=&quot;text/javascript&quot;&gt;
        
        // Load the Visualization API and the piechart package.
        google.load(&#39;visualization&#39;, &#39;1&#39;, {&#39;packages&#39;:[&#39;corechart&#39;]});
          
        // Set a callback to run when the Google Visualization API is loaded.
        google.setOnLoadCallback(drawChart);
          
        function drawChart() {
          
          // Create our data table out of JSON data loaded from server.
          var data = new google.visualization.DataTable(&lt;?=$jsonTable?&gt;);
    	  var options = {
               title: &#39;My Weekly Plan&#39;,
    		  is3D: &#39;true&#39;,
    		  width: 800,
    		  height: 600
            };
          // Instantiate and draw our chart, passing in some options.
    	  // Do not forget to check your div ID
          var chart = new google.visualization.PieChart(document.getElementById(&#39;chart_div&#39;));
          chart.draw(data, options);
        }
        &lt;/script&gt;
      &lt;/head&gt;
    
      &lt;body&gt;
        &lt;!--this is the div that will hold the pie chart--&gt;
        &lt;div id=&quot;chart_div&quot;&gt;&lt;/div&gt;
      &lt;/body&gt;
    &lt;/html&gt;

&lt;br/&gt;
**PHP-PDO-JSON-MySQL-Google Chart Example:**

        
    &lt;?php
        /*
        Script  : PHP-PDO-JSON-mysql-googlechart
        Author  : Enam Hossain
        version : 1.0
        
        */
        
        /*
        --------------------------------------------------------------------
        Usage:
        --------------------------------------------------------------------
        
        Requirements: PHP, Apache and MySQL
        
        Installation:
        
          --- Create a database by using phpMyAdmin and name it &quot;chart&quot;
          --- Create a table by using phpMyAdmin and name it &quot;googlechart&quot; and make sure table has only two columns as I have used two columns. However, you can use more than 2 columns if you like but you have to change the code a little bit for that
          --- Specify column names as follows: &quot;weekly_task&quot; and &quot;percentage&quot;
          --- Insert some data into the table
          --- For the percentage column only use a number
        
              ---------------------------------
              example data: Table (googlechart)
              ---------------------------------
        
              weekly_task     percentage
              -----------     ----------
              
              Sleep           30
              Watching Movie  10
              job             40
              Exercise        20     
        
        
        */
        
        /* Your Database Name */
        $dbname = &#39;chart&#39;;
        
        /* Your Database User Name and Passowrd */
        $username = &#39;root&#39;;
        $password = &#39;123456&#39;;
        
        try {
          /* Establish the database connection */
          $conn = new PDO(&quot;mysql:host=localhost;dbname=$dbname&quot;, $username, $password);
          $conn-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
          
          /* select all the weekly tasks from the table googlechart */
          $result = $conn-&gt;query(&#39;SELECT * FROM googlechart&#39;);
        
          /*
              ---------------------------
              example data: Table (googlechart)
              --------------------------
              weekly_task     percentage
              Sleep           30
              Watching Movie  10
              job             40
              Exercise        20       
          */
         
        
        
          $rows = array();
          $table = array();
          $table[&#39;cols&#39;] = array(
        
            // Labels for your chart, these represent the column titles.
            /* 
                note that one column is in &quot;string&quot; format and another one is in &quot;number&quot; format 
                as pie chart only required &quot;numbers&quot; for calculating percentage 
                and string will be used for Slice title
            */
        
            array(&#39;label&#39; =&gt; &#39;Weekly Task&#39;, &#39;type&#39; =&gt; &#39;string&#39;),
            array(&#39;label&#39; =&gt; &#39;Percentage&#39;, &#39;type&#39; =&gt; &#39;number&#39;)
        
        );
            /* Extract the information from $result */
            foreach($result as $r) {
              
              $temp = array();
             
              // the following line will be used to slice the Pie chart
              
              $temp[] = array(&#39;v&#39; =&gt; (string) $r[&#39;weekly_task&#39;]); 
        
              // Values of each slice
              
              $temp[] = array(&#39;v&#39; =&gt; (int) $r[&#39;percentage&#39;]); 
              $rows[] = array(&#39;c&#39; =&gt; $temp);
            }
        
        $table[&#39;rows&#39;] = $rows;
        
        // convert data into JSON format
        $jsonTable = json_encode($table);
        //echo $jsonTable;
        } catch(PDOException $e) {
            echo &#39;ERROR: &#39; . $e-&gt;getMessage();
        }
        
        ?&gt;
        
        
        &lt;html&gt;
          &lt;head&gt;
            &lt;!--Load the Ajax API--&gt;
            &lt;script type=&quot;text/javascript&quot; src=&quot;https://www.google.com/jsapi&quot;&gt;&lt;/script&gt;
            &lt;script type=&quot;text/javascript&quot; src=&quot;http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js&quot;&gt;&lt;/script&gt;
            &lt;script type=&quot;text/javascript&quot;&gt;
        
            // Load the Visualization API and the piechart package.
            google.load(&#39;visualization&#39;, &#39;1&#39;, {&#39;packages&#39;:[&#39;corechart&#39;]});
        
            // Set a callback to run when the Google Visualization API is loaded.
            google.setOnLoadCallback(drawChart);
        
            function drawChart() {
        
              // Create our data table out of JSON data loaded from server.
              var data = new google.visualization.DataTable(&lt;?=$jsonTable?&gt;);
              var options = {
                   title: &#39;My Weekly Plan&#39;,
                  is3D: &#39;true&#39;,
                  width: 800,
                  height: 600
                };
              // Instantiate and draw our chart, passing in some options.
              // Do not forget to check your div ID
              var chart = new google.visualization.PieChart(document.getElementById(&#39;chart_div&#39;));
              chart.draw(data, options);
            }
            &lt;/script&gt;
          &lt;/head&gt;
        
          &lt;body&gt;
            &lt;!--this is the div that will hold the pie chart--&gt;
            &lt;div id=&quot;chart_div&quot;&gt;&lt;/div&gt;
          &lt;/body&gt;
        &lt;/html&gt;

&lt;br/&gt;
**PHP-MySQLi-JSON-Google Chart Example**

    &lt;?php
    /*
    Script  : PHP-JSON-MySQLi-GoogleChart
    Author  : Enam Hossain
    version : 1.0
    
    */
    
    /*
    --------------------------------------------------------------------
    Usage:
    --------------------------------------------------------------------
    
    Requirements: PHP, Apache and MySQL
    
    Installation:
    
      --- Create a database by using phpMyAdmin and name it &quot;chart&quot;
      --- Create a table by using phpMyAdmin and name it &quot;googlechart&quot; and make sure table has only two columns as I have used two columns. However, you can use more than 2 columns if you like but you have to change the code a little bit for that
      --- Specify column names as follows: &quot;weekly_task&quot; and &quot;percentage&quot;
      --- Insert some data into the table
      --- For the percentage column only use a number
    
          ---------------------------------
          example data: Table (googlechart)
          ---------------------------------
    
          weekly_task     percentage
          -----------     ----------
          
          Sleep           30
          Watching Movie  10
          job             40
          Exercise        20     
    
    
    */
    
    /* Your Database Name */
    
    $DB_NAME = &#39;chart&#39;;
    
    /* Database Host */
    $DB_HOST = &#39;localhost&#39;;
    
    /* Your Database User Name and Passowrd */
    $DB_USER = &#39;root&#39;;
    $DB_PASS = &#39;123456&#39;;
    
    
    
    
    
      /* Establish the database connection */
      $mysqli = new mysqli($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);
      
      if (mysqli_connect_errno()) {
        printf(&quot;Connect failed: %s\n&quot;, mysqli_connect_error());
        exit();
      }
      
       /* select all the weekly tasks from the table googlechart */
      $result = $mysqli-&gt;query(&#39;SELECT * FROM googlechart&#39;);
    
      /*
          ---------------------------
          example data: Table (googlechart)
          --------------------------
          Weekly_Task     percentage
          Sleep           30
          Watching Movie  10
          job             40
          Exercise        20       
      */
     
    
    
      $rows = array();
      $table = array();
      $table[&#39;cols&#39;] = array(
    
        // Labels for your chart, these represent the column titles.
        /* 
            note that one column is in &quot;string&quot; format and another one is in &quot;number&quot; format 
            as pie chart only required &quot;numbers&quot; for calculating percentage 
            and string will be used for Slice title
        */
    
        array(&#39;label&#39; =&gt; &#39;Weekly Task&#39;, &#39;type&#39; =&gt; &#39;string&#39;),
        array(&#39;label&#39; =&gt; &#39;Percentage&#39;, &#39;type&#39; =&gt; &#39;number&#39;)
    
    );
        /* Extract the information from $result */
        foreach($result as $r) {
          
          $temp = array();
         
          // The following line will be used to slice the Pie chart
          
          $temp[] = array(&#39;v&#39; =&gt; (string) $r[&#39;weekly_task&#39;]); 
    
          // Values of the each slice
          
          $temp[] = array(&#39;v&#39; =&gt; (int) $r[&#39;percentage&#39;]); 
          $rows[] = array(&#39;c&#39; =&gt; $temp);
        }
    
    $table[&#39;rows&#39;] = $rows;
    
    // convert data into JSON format
    $jsonTable = json_encode($table);
    //echo $jsonTable;
    
    
    ?&gt;
    
    
    &lt;html&gt;
      &lt;head&gt;
        &lt;!--Load the Ajax API--&gt;
        &lt;script type=&quot;text/javascript&quot; src=&quot;https://www.google.com/jsapi&quot;&gt;&lt;/script&gt;
        &lt;script type=&quot;text/javascript&quot; src=&quot;http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js&quot;&gt;&lt;/script&gt;
        &lt;script type=&quot;text/javascript&quot;&gt;
    
        // Load the Visualization API and the piechart package.
        google.load(&#39;visualization&#39;, &#39;1&#39;, {&#39;packages&#39;:[&#39;corechart&#39;]});
    
        // Set a callback to run when the Google Visualization API is loaded.
        google.setOnLoadCallback(drawChart);
    
        function drawChart() {
    
          // Create our data table out of JSON data loaded from server.
          var data = new google.visualization.DataTable(&lt;?=$jsonTable?&gt;);
          var options = {
               title: &#39;My Weekly Plan&#39;,
              is3D: &#39;true&#39;,
              width: 800,
              height: 600
            };
          // Instantiate and draw our chart, passing in some options.
          // Do not forget to check your div ID
          var chart = new google.visualization.PieChart(document.getElementById(&#39;chart_div&#39;));
          chart.draw(data, options);
        }
        &lt;/script&gt;
      &lt;/head&gt;
    
      &lt;body&gt;
        &lt;!--this is the div that will hold the pie chart--&gt;
        &lt;div id=&quot;chart_div&quot;&gt;&lt;/div&gt;
      &lt;/body&gt;
    &lt;/html&gt;

PHP MySQL Google Chart JSON - Complete Example

I have a chart that I want to include in my website using [Chart.js][1]. In the Y-axis, it gives me real numbers instead of integers. How can I change the number to integers?

Here&#39;s a picture of what I have now: 

[![current chart with real numbers][2]][2]


And this is the code:

	var lineChartData = {
                        
		labels : [&quot;2013/04/01&quot;,&quot;2013/03/31&quot;, &quot;2013/03/30&quot;, &quot;2013/03/29&quot;, &quot;2013/03/28&quot;,&quot;2013/03/27&quot;, &quot;2013/03/26&quot;],
      
		datasets : [
			{
				fillColor : &quot;rgba(151,187,205,0.5)&quot;,
				strokeColor : &quot;rgba(151,187,205,1)&quot;,
				pointColor : &quot;rgba(151,187,205,1)&quot;,
				pointStrokeColor : &quot;#fff&quot;,
				data : [&quot;0&quot;, &quot;2&quot;,&quot;1&quot;, &quot;0&quot;, &quot;1&quot;,&quot;0&quot;,&quot;1&quot;]
			}
		]
			
	}

	var myLine = new Chart(document.getElementById(&quot;canvas&quot;).getContext(&quot;2d&quot;)).Bar(lineChartData);


  [1]: http://www.chartjs.org/
  [2]: http://i.stack.imgur.com/F9nUW.png

Change the Y-axis values from real numbers to integers in Chart.js

In Matplotlib, it&#39;s not too tough to make a legend (`example_legend()`, below), but I think it&#39;s better style to put labels right on the curves being plotted (as in `example_inline()`, below). This can be very fiddly, because I have to specify coordinates by hand, and, if I re-format the plot, I probably have to reposition the labels. Is there a way to automatically generate labels on curves in Matplotlib? Bonus points for being able to orient the text at an angle corresponding to the angle of the curve.

    import numpy as np
    import matplotlib.pyplot as plt

    def example_legend():
        plt.clf()
        x = np.linspace(0, 1, 101)
        y1 = np.sin(x * np.pi / 2)
        y2 = np.cos(x * np.pi / 2)
        plt.plot(x, y1, label=&#39;sin&#39;)
        plt.plot(x, y2, label=&#39;cos&#39;)
        plt.legend()

![Figure with legend][1]

    def example_inline():
        plt.clf()
        x = np.linspace(0, 1, 101)
        y1 = np.sin(x * np.pi / 2)
        y2 = np.cos(x * np.pi / 2)
        plt.plot(x, y1, label=&#39;sin&#39;)
        plt.plot(x, y2, label=&#39;cos&#39;)
        plt.text(0.08, 0.2, &#39;sin&#39;)
        plt.text(0.9, 0.2, &#39;cos&#39;)

![Figure with inline labels][2]


  [1]: http://i.stack.imgur.com/l50U7.png
  [2]: http://i.stack.imgur.com/wDyVf.png

Content Type	Original Author	Original Content on Stackoverflow
Question	ASP	View Question on Stackoverflow
Solution 1 - Android	Ewoks	View Answer on Stackoverflow
Solution 2 - Android	Dr. Andrew Burnett-Thompson	View Answer on Stackoverflow

Charts for Android

Android Problem Overview

Android Solutions

Solution 1 - Android

Solution 2 - Android

support FragmentPagerAdapter holds reference to old fragments

How to add an extra source directory for maven to compile and include in the build jar?

Attributions