6 Replies Latest reply on Oct 29, 2018 1:58 AM by sravani adapa

# How to achieve following condition in stack bar chart with 2 color shading (1 from stack bar and other from calculation)

How can i create stack bar chart with 2 color shading, Please find the example below. Right now i am able to achieve bar and line chart, but unable to get stacked bar chart with two color shading as shown below.

Can anyone help me on the same.

Explanation: The bar chart represent sales by sub category in ascending order and line chart represent  % of sales in running total and color is represented as >80 % in blue color and more than 80% in red color. So i want to create a stacked bar chart, for actual  and target sales, in which for records >80 % can be in light and dark blue color and records which are more than 80% they should be   light and dark red color.

• ###### 1. Re: How to achieve following condition in stack bar chart with 2 color shading (1 from stack bar and other from calculation)

Can you explain little bit more about those stacked colors, what it represents in your bar graph?

• ###### 2. Re: How to achieve following condition in stack bar chart with 2 color shading (1 from stack bar and other from calculation)

The bar chart represent sales by sub category in ascending order and line chart represent  % of sales in running total and color is represented as >80 % in blue color and more than 80% in red color. So i want to create a stacked bar chart, for actual  and target sales, in which for records >80 % can be in light and dark blue color and records which are more than 80% they should be   light and dark red color.

Hope you are able to understand my scenario .

• ###### 3. Re: How to achieve following condition in stack bar chart with 2 color shading (1 from stack bar and other from calculation)

Sorry, I couldn't understand properly

Could you please explain the difference between these statements which you've mentioned in your explanation?

And

• ###### 4. Re: How to achieve following condition in stack bar chart with 2 color shading (1 from stack bar and other from calculation)

When i make data in descending order , then i will see sub category which contribute more on sales....so i have created a calculation % sales (running total %),  that will give me % of sales in running total, so i am giving one color for sub category which contribute 80% of sales and 80~100 % for which i have give another color.........in this way i can see the sub category which is more important me.......

So i want to create stack bar chart in place of bar chart, in which i will show actual and target sales with addition to above condition for color  .

• ###### 5. Re: How to achieve following condition in stack bar chart with 2 color shading (1 from stack bar and other from calculation)

Hi,

Thanks for explaining your requirement once again. As far as I understand is you wants to check which are the sub-categories which contributes 80% of over sales as well as meeting the target sales. Correct me if I'm wrong.

Here is my approach, have a look and let me know if this help. For getting the stack you have to work on the data structure little bit.

Mahfooj

• ###### 6. Re: How to achieve following condition in stack bar chart with 2 color shading (1 from stack bar and other from calculation)

Hi Sparsh Jain,

Please find the attachment if you are usefull.

Thanks,

Sravani