3 Replies Latest reply on Sep 15, 2016 6:46 AM by aditya.wresniyandaka

# stacked bar chart with line combination or side by side bar with line

Hello Experts,

Greetings of the day,

I am strucked with one problem how can i get the side by side bar or Stacked bar chart with two categories and line as a grandtotal on top of stacked bar chart

here i am attaching the sample data could you please help me on this issue tomorrow is the deliverday any one please cpme forward and give a solution Quickly

i will be great full to you

Here i am attaching Sample Excel file please refer it

Requirement

1) Number is the Common column between all the 3 tables in provided excel sheet

2) In KN_PHYSICAL_ST table NUMBER =Smodel+Chno this would be the Common column among all the 3 tables

KN_Physical_State

1. 1. DOM/EXP

When DOM/EXP = ‘4’ then it is N-D

When DOM/EXP = ‘1’ then it is N-E

When DOM/EXP = ‘3’ then it is R-E

When DOM/EXP = ‘2’ then it is R-D

in KN_PHYSICAL_ST table   NUMBER =Smodel+Chno

Join KN_Credit_Status table with KN_Physical_State table with NUMBER and get DOM/EXP details of a particular NUMBER in KN_Credit_Status table from KN_Physical_state table. Then count the number of Products in R and N in KN_Credit_State table.

Date is Credit check date in KN credit  status table

1) Requirement

the count may vary no issues but i need to get exact image in tableau ,

if it is not possible with stack bar along with line also no problem

But line graph is Grand total of both

please any one quickly help me i think  it would be easier to experts

• ###### 1. Re: stacked bar chart with line combination or side by side bar with line

I was able to create stacked bars and line. Essentially, you will have to create a dual axis chart. The count of DOM/EXP as one axis, create a stack bar, and turn off Auto stack (Analysis - Stack Marks Off). Drag the sum of records to the right axis and change the type to Line.

It will look like this; the blue and orange bars are the count of DOM/EXP, and the red line is the sum.

Attached is the workbook.

1 of 1 people found this helpful