Stacked Bar Chart with Line

[manojkulkarni]

Hi Friends,

I have one requirement, in which i am displaying stacked bar chart for 2 dimensions. Now user wants to add Line to show the trend of same data. How should we achieve ?

Attached the expected output

[PrashantSangle]

USe combo chart..

Regards

[PrashantSangle]

Hi,

In expression tab add 1 expression > Select Display Option > Bar

In expression tab add 2 expression > Select Display Option > Bar

In Style > SubType > select stack.

In expression tab add 3 expression > Select Display Option > Line

Regards

[manojkulkarni]

I have 2 dimensions  & single expression to be used

[manojkulkarni]

Below is the sample data. Using Month & Priority as dimension & Value in expression. Priority values are not fixed, so cann't hard code the expression as well.

Month	Priority
Feb-16	Low	28
Mar-16	High	1
Mar-16	Low	33
Apr-16	Low	16
May-16	Low	16
Jun-16	Medium	1
Jun-16	Low	18
Jul-16	Low	7

[Anil_Babu_Samineni]

Manoj, Can i know what is your Dimensions and can you please share me the Sample App which demonstrates to understand the problem. Here, The best way to achieve is Combo Chart only. If your dimensions are Month and Priority what is the expression you are trying to show

What exactly your Req?

[manojkulkarni]

My Dimensions will be MonthYear & Priority, expression will be sum of Values.

Would like to see Stacked bar chart per month and along with the bars there should be a line to show the trend. Trend line is nothing but the total value of the corresponding month.

[danansell42]

Hi Manoj

is the attached what you are looking for?

Dan

[#9]

Hi Manoj

You need to create 3 bar expressions for priorities using set analysis and one line expression for total value.

See attached for details

Regards, VJ

[rubenmarin]

Hi Manoj, one option is overlapping two charts:

- One for stacked bars in upper layer to make selections. Transparent background (in color tab). Using CTRL+MAYS to fix the legend area so it doesnt' moves.

- The 2nd with the trend line in a lower layer, removing axes, legends and everything else and place it where it fits with the chart area of the upper chart.

It's supposed that two charts will have the same axis values, if not you'll need to fix them using the max and min in the axis tab to keep the same range in both charts.