value expression in charts

[fleur]

Hello,

I want to make a chart with all columns of my table in the x axis (category expression) and their value in y axis (value expression). The problem is that their values in y axis are not numeric, they are carachters('-','=','+' or '++').

I want my result to be something like this 

help me please

[darth_fader]

You could do a simple substitution like - = 1, = = 2, + = 3, ++ = 4 for the x axis values, via an if/then expression. Substitute your characters for integer values. Then use a custom expression to display the tick marks on the x axis. If that doesn't work, you could always create a chart customizer.

Some sample customizer code is available here:

 

https://mdahlman.wordpress.com/2011/04/17/chart-customizers-2/

[fleur]

hi, thank you for your reply

I did the substitution of my characters into integers, but now i want my charachters to appear not integers and didn't know how to do that. could you explain me more about custom expression and how to make it

Thanks a lot