how to draw a chart

[alexander.qna]

Hi all,

I am trying to draw a Matrix chart as in the image attach but did not find anyway to create that chart after much exploration.

Is it possible at all?

Thanks.

Regards,

Alex

[alexander.qna]

Hi again,

Another question. Is it possible to produce a bell curve? I am able to produce line chart but was not able to get the curve on 0 at both ends.

Also I have a scatter chart plotted but the label text on the same dots overlaps each other which makes the text unreadable.

Is there anyway to set it so that the text do not overlap?

Thanks.

Alex

[Vaughan]

I've always believed that FMP is great for entering and storing data, however data visualisations should be done in a specialist program using data exported from FMP.

[jbante]

By "bell curve," I'm assuming that you mean a normal (Gaussian) distribution. There is no zero in this distribution to plot at either end — the ends only approach zero asymptotically. If you really need a bell-shaped curve with zeros at both ends, consider a Beta distribution instead — though the math to implement that is substantially messier.

With either distribution, the best we can plot is an approximation to the distribution. Plotting more points and using the curved line chart should give you the closest result.

[org]

Had a brief moment when looked at similar last year in 11 - didn't get far and wasn't important enough to pursue but just had quick go with v12 scatter chart as better suited.

Also lot more UI options in graph help - see attached - not ideal not miles away.

note: couldn't find way to turn off the graphing area border - doesn't seem to be a way?

overlapping points bit of problem ( print on top of each other ) - might need some data massage if duplicate points data i.e amend y axis data a bit just for graphing so point shows on graph.

Rgds

Olly

Matrix Chart.fmp12.zip