barchart

[#1]

Hi all

I have one requirement

i have to create a bar chart and half of the bars should show one color remaining half bars should show another color

how can we do  plz help

Regards

Panireddy

[#2]

Hi,

CAn you please eloborate your requirement ....with sample file or data

Regards

Nani

[#3]

Hi Panireddy,

The easiest option is to set the colors in "Colors" tab.

Right click on the chart, go to Properties--Colors tab and in the "Data Appearance" section you can customize the colors for the bar.

Hope this helps. Otherwise, please add a sample file.

[MK_QSL]

Creat a bar char

example

Dimension = Customer

Expression1 = SUM(Sales)/2

Expression2 = SUM(Sales)/2

Now go to Style tab and select Stacked.

UPDATE : Please check enclosed file...

[sunilkumarqv]

Hi Pn Reddy,

Go to properties - Style - Choose -subtype as stacked it works but should have  more then on expression in your chart

If not these .more specific what you want so it easy to solve 

[jsingh71]

Hi,

First you add two expressions and after that go to chart properties and select stacked option.

[#7]

Hi Nani

12 bars are there my requirement is 6 bars should show green and another 6 bars should show yellow how can do

[jsingh71 · Accepted solution]

hi,

Go to chart properties the Expression Tab and expand + sign from your dimension and select background color.

After that put this expression:

  if(FieldIndex('Month',Month)>6,Green(),Red())

It will solve your problem and you get output like

[#9]

Hi

Here 12 bars are there my requirement is 6 bars should show green and another 6 bars should show yellow how can do

[jsingh71]

I alredy told you, instead of Red() use Yellow().