bar chart and line chart integration in a single chart

[get.arijit]

Hi

 

I want to create a combination chart with bar chart and line chart using php. Please share me any sample code which help me to sort out my problem. 

 

I have a mysql data base which contains a table like the below: 

 

Date   TagValue        Cumulitive Tag Value

----       -------             -------------------------

1/1/2016    60                 60

1/2/2016    80               140

1/3/2016    70               210

1/4/2016    80               290

1/5/2016   50              340

 

 

Now I want to create a combination chart of bar and line chart which will show Month in x axis

and Tag Value in Y1 axis (in bar chart) and Cumulitive Value in Y2 axis( in line chart)

 

Please help me.

 

Thanks in advance

 

 

 

[Prerana]

Hello,

 

Thanks for the query.

 

The combination of bar chart and line chart is not supported.

 

Instead of bar chart , you could use the combination of column chart and line chart.

 

Kindly refer the link below, for the implementation.

https://www.dropbox.com/s/ep26pqwgo4gv1sd/Chart.zip?dl=0

 

Hope this helps,

[get.arijit]

Thank you very much Prerana. 

 

Let me try with your solution.

My another problem is that I will have to run my pages in a PC which will have no internet connection. But to view the chart I have to include the below JS file. 

 

<script type="text/javascript" src="http://static.fusioncharts.com/code/latest/fusioncharts.js"></script>

 

Due to unavailability of internet, this js script will not run. SO is there any way to download that script and keep the script in my  PC. 

 

I think it makes sense to you. 

 

Thanks,

Arijit Dutta

[Prerana]

Hello,

 

Kindly download FusionCharts Suite XT, using the link given below. 

http://www.fusioncharts.com/download/

 

This suite contains all the required js files. Extarct those files, and use them as per your requirement.

 

Hope this helps,

[jgendorn]

 

Hello,

 

Kindly download FusionCharts Suite XT, using the link given below. 

https://address-data.co.uk

 

This suite contains all the required js files. Extarct those files, and use them as per your requirement.

 

Hope this helps,

 

Thanks for pointing this out. My graphs were not loading without the net connection.

Edited January 7, 2017 by jgendorn

[Prerana]

Thanks for pointing this out. My graphs were not loading without the net connection.

Hello,

 

Glad to know that it worked.

[amily]

On 2016-12-20 at 1:32 PM, Prerana said:

Hello,

 

Thanks for the query.

 

The combination of bar chart and line chart is not supported.

 

Instead of bar chart , you could use the combination of column chart and line chart.

 

Kindly refer the link below, for the implementation.

https://address-search.co.uk

 

Hope this helps,

 

Works for me thanks