Bar chart

[nareshthavidishetty]

Hi,

We are having store(12,15,17,..),date and measure as sum(sales).I need to show this detail in bar chart as below image.

Thanks..

[kkkumar82]

Like this ??

[kkkumar82]

PFA qvw file

[stigchel]

For plotting text inside the bars you can use the dual(text, number) function. It will take the text value for labels and the number for the height of the bars.

For the display of text AND values above the bar, you can maybe use a combo chart with a (invisible) line for the values above the bars. This will only work with a single dimension and both text and value in vertical presentation.

For more than one dimension you will have to display both text and value inside the bar.

Alternatively overlay two bar charts to meet all your needs...

[stigchel · Accepted solution]

Qvw attached

[susovan]

You can also follow this below process:

[Anonymous]

Simply take

Date and Store as dimension in Bar

Sum(Sales) as Expression

Any issue?

[saimahasan]

You can take store in expression and check the "Plot Values inside Segments" option in Presentation tab.

[nareshthavidishetty]

Hi,

Can i get multi color chart.

Thanks..

[stigchel]

Click on the +sign in front of the bar amount expression (in my example) and put in the background color expression

=Color(Rowno())

where to find: