Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

qvmyself
New Contributor

Design of the bars in a bar chart

Hi all,

I'm trying to visualize my bar chart like my example (s.o./Excel), but cannot do it better than the result below:barchart_excel_vs_qlikview.JPG.jpg

So, is there a way to do it like that?

Many thanks,

M.

Tags (3)
9 Replies

Re: Design of the bars in a bar chart

Go to Chart Properties, color tab and untick Multicolored

Now Select the first color from Data Appearance and from Colors 1-16

make transparency to 100%

qvmyself
New Contributor

Re: Design of the bars in a bar chart

Thank you, but I tried it before and lost the colors I'd like to have for the borders of the bars.

rustyfishbones
Honored Contributor II

Re: Design of the bars in a bar chart

not sure of an easy way to do this, but would like to know

I Changed the Style to below settings

2014-01-29_1104.png

And then I played around with the Transparency, which gets close to what you want, but not exactly what you want

It would be nice to see if this could be done

Re: Design of the bars in a bar chart

As far as my knowledge, there is no separate setting for BAR CHART - BAR BORDER color setting.

May be someone can suggest this can be done by MACRO....

ashwanin
Valued Contributor

Re: Design of the bars in a bar chart

If you want the chart Multicolured then

Open chart- Properties-Colors and then select Multicolored in date apperance

and if you want to display the bars w/o colour then

open Chart-Properties-Expressions then click on exprssion sign - Background colour- in defintion field put value (0), it will make your graph colourless.

qvmyself
New Contributor

Re: Design of the bars in a bar chart

Maybe I do not unterstand, but I want my chart neither multicolored nor colorless. I struggle while trying to set the border color to make my chart look like the first one in the pic.

ashwanin
Valued Contributor

Re: Design of the bars in a bar chart

Yes this is what i said in colourless, You have to do two things

1:open Chart-Properties-Expressions then click on exprssion sign - Background colour- in defintion field put value (0), it will make your graph colourless.

and 2: Make border width to 2 point or according to your requirement.

rgds

AshwaniCapture.PNG.png

Re: Design of the bars in a bar chart

Sorry but the requirements are

1) Bar should be having NO COLOR

2) All Bar's border should be having color....

qvmyself
New Contributor

Re: Design of the bars in a bar chart

Thanks for the support and sorry that I do not understand the ways to solve my problem, but the rusult doing it like you said are black-bordered (main problem!) colorless bars.

Community Browser