Can CRChart accommodate this?

[KerryReid]

Hi Guys

Sorry for the uninformative question name?

Excel Data
Chart

See the links above, I'm fairly certain I can do all the basic stuff like min, max, iqr and the placement of an icon for a particular users score.

My main question is, can I use the multiple different columns as the series, so, d1, d2, d3, total, etc.....

If yes, thena bit of help please!

If no, the any suggestions would be appreciated.

Thanks

Kerry

[KerryReid]

Chart Image

Ok, I have managed to cheat a bit and do a dfifferent chart for each column in the data.

My issue now is the placement of my marker, why pray tell is it buggering around at the absolute top of my chart, how do I centre it on the horizontal line running through?

Cheers

Kerry

[TDGMgr]

Hi Kerry,

Try @MK 1 to see if that will center your marker on the horizontal boxplot.

http://www.threedgraphics.com/tdg/products/tools/crchart/html_docs/docs/macros/mk.htm

Also, you could use @USER_FILL to create the banding effect on the chart background.

http://www.threedgraphics.com/tdg/products/tools/crchart/html_docs/docs/macros/user_fill.htm

[KerryReid]

You rock mate!

Thanks for the help, I'll shout if I need anything else.

For the record I did try to have a look but you have a rather large set of macros and I am rubbish at RTFM

Kerry