Double y line (same value) with trendline (2nd order polynomial)

[reezwan]

Hi,

I am trying to plot a stack bar with 4 series of data. 1st and 2nd series should display the difference of two series(e.g. income for year 2007 and 2008) and 3rd and 4th series will able to plot two different trend line (polynomial- e.g. 25th and 75th percentile value). I was able to do it on Excel, and also able to show the positive and negative difference with different color coding(e.g. blue and red). Can we plot two y bar with same value? show the differences on two series? plot the trend line?

Any suggestion would be appreciated in regards to plotting with fusion chart.

Regards,

reezwan

[saptarshi]

Hello Reezwan,

 

 

 

Welcome to the forum.

 

 

 

Could you please check the following chart on our gallery and see if this is similar to what you have in mind? (not data wise, just the features in the chart)?

 

 

 

http://www.fusioncharts.com/gallery/Chart.asp?msstackedcolumn3dlinedy_1

 

 

 

Things like first and second column displaying the difference of two data series, will have to be done programmatically to produce the required XML. The charts cannot perform any data manipulation.

 

 

 

Send your feedback and we will try to help you achieve exactly what you need.

 

 

 

Hope this helps.

[reezwan]

Many thanks for your prompt reply. The candlestick bar does the trick for me. Just a little question though, how can I plot a smooth trend line (polynomial, exponential etc). Currently the trendline is linear, bisecting every discrete points.

Any help would be appreciated.

Regards,

Reezwan

[Guest Rajroop]

Hello Reezwan,

 

 

 

Trendlines are horizontal/vertical lines spanning the chart canvas which aid in interpretation of data with respect to some pre-determined value.

 

 

 

Unfortunately, the exponential/polynomial functionality is not available in Trendlines, as of now.

 

 

 

Your suggestions are very important to us. We have made a note of this.

[reezwan]

Thanks mate, love your work, eagerly waiting to see this features so we can do some prediction model. How long before you reckon we can see this in fusion chart, its there on Excel

[Guest Rajroop]

Hello Reezwan,

 

 

 

There is no time span that we can predict or even mention, at the moment, for this feature upgrade.

[reezwan]

thanks, I am not the techi kinda person, some other admin suggested me to use column 3D, double line chart. Can you tell me how to get the difference out of two bar diagram and plot it in a chart. Candle stick no use for me knowing no exponential/polynomial curve.

regards,

reezwan

[Guest Rajroop]

Hello Reezwan,

 

 

 

I'm a bit unsure of the type of data that you're dealing with. Thereby, a chart type suggestion would involve a detailed account of the type of data involved. Could you please provide us with an idea of the same?

 

 

 

Also, could you please take a look at our Gallery and see which chart suits your needs best? Please refer to the link : http://www.fusioncharts.com/gallery

 

 

 

I hope this helps.

[Guest Angie]

Dear User,

 

We are delighted to announce that PowerCharts is now ready for your iPads and iPhones too. We have just released PowerCharts v3.2. Starting v3.2, PowerCharts has HighCharts embedded within it, and offers both Flash and JavaScript (HTML5) charting . The Flash charts are displayed on a majority of devices and the JavaScript charts on devices that do not support Flash, all of it without writing a line of code.

 

Automatic rendering of JavaScript charts on devices (like iPad and iPhone) where Flash player is not supported.

 

5 new chart types:

 

Heat Map Chart

 

Box and Whisker Chart

 

Step Line Chart

 

Error Line Chart

 

Error Scatter Chart

 

 

* Support for JSON data format.

 

* Support for LinkedCharts, where a single data source controls multiple charts.

 

* Interactive legends in charts allow selective showing/hiding of data series.

 

* Legends now support icons for each data series.

 

* Better management of labels on charts.

 

* Labels now have an auto rendering mode to prevent them from overlapping, the chart selects the best display mode depending on the length of the labels and the width of the chart.

 

* Long labels are truncated, with ellipses appended to the truncated end of each label, and a tooltip bearing the completed label text is displayed when the user hovers over a truncated label.

 

* Support for line breaks and wrapping in all text elements including: caption, sub caption, X-axis title, Y-axis title, Labels and tooltips.

 

* In Line charts, data values can now be positioned either above or below the dataplots. Automatic positioning of data values is also supported.

 

* In Step-line charts dataplots can be joined using vertical lines.

 

* Custom alignment of caption and sub caption using STYLES.

 

* Advanced print management using JavaScript.

 

* Additional options for efficient event handling using JavaScript.

 

* Support for dynamic update of chart properties using JavaScript(barring select scatter and drag charts).

 

* Charts now support % based sizes along with dynamic resizing (barring select scatter and drag charts).

 

 

Learn more about everything new in PowerCharts v3.2 at : http:/ www.fusioncharts.com/PowerCharts/

 

We would love to hear from you at: http://www.fusioncharts.com/contact/