Which Chart Should I Use?

[pyrite]

Hello, I have a table of data I'm using, and can't decide on the best way to graph/chart the data I have, so there is no real right or wrong answer, but I'd like some ideas if you don't mind.

 

The data I have looks like this:

 

 

Appreciate any ideas anyone has. Obviously the goal is to convey the data in a manner that is easy for users to understand.

[Guest Angshu]

Hi,

Welcome to FusionCharts Forum!

 

I think Gantt chart present in FusionWidgets of FusionCharts suite will suffice your requirement.

 

The Gantt chart is a specialized chart used for displaying various timelines like project timelines, development timelines etc.

 

For more details, please visit the links below:

 

http://www.fusioncha...ttOverview.html

 

http://www.fusioncha...nttAnatomy.html

 

http://www.fusioncha...GanttFirst.html

 

http://www.fusioncha...anttConfig.html

 

Hope this helps.

 

 

[pyrite]

Does anyone else have any thoughts, because I kind of think a Gant chart is too complex for this small amount of data.

 

I was thinking about a stacked column chart, where the total goal is the column, and the stacked part is the % of goal reached, but I couldn't get the stacked chart to work like that.

[Guest Angshu]

Hi,

 

Thanks for your response.

 

Please find the sample zip file and the screenshot attached for your reference.

 

Here, we have rendered a multi series column 2D chart and a stacked chart based on the data provided by you.

 

Hope this helps.

Charts.zip

[pyrite]

I'm sorry, but neither of those charts represent the data very well.

 

In the first one, the 4th column is a percentage, rendered against a Y-axis of numbers, that don't mean anything.

 

In the 2nd chart, the stacked values do not collectively form a whole.

 

What I would like is a stacked chart, and let's pretend we only have goal (number) and goal reached (percent of goal number). Is there a way to make the goal reached portion be stacked and visually identify how much of the goal was reached? So let's say the goal is RED and the goal reached is GREEN. If the two matched, you would just see a solid green bar that goes up to the goal. If they don't match, let's say goal was 100 and goal reached was 80, you would see a red column going up to 100 and a green column over it going up to 80. Can that be done? When I tried this, it took the two values and stacked them so I had one bar going up to 180 instead, like it's adding the value together.

[pyrite]

I guess my real question is, in a stacked column chart, how to make the second dataseries start at 0, instead of where the previous dataseries left off?

[Sanjukta]

Hi,

 

Could you please try using Combination 2D Dual Y chart for solving your purpose?

Ref.- http://www.fusioncharts.com/docs/?ChartSS/Combi2DDY.html

 

Also, please note that Stacked charts mean that only data plot would be placed on top of the other to finally provide the sum of all the values. In case you wish to start all the data plots from "0", please try using Multi-series Column 2D chart.

 

It would be really helpful if you can provide us with a screenshot of your requirement.

 

Looking forward to your feedback.