Show color bar even when no data in bar chart

Question

How to show color for bars in a stacked bar chart even if no data or zero value for the calculation or measure is present?

Answer 1

Hi Latha,

Follow the below steps:

1. Create the bar chart as required. ( For ex. below)

2. Craete a calculted field with any constant value or create a fixed avg(measure).

3. Now add the created field in the sheet.

4. Now make a dual axis chart.

Thus in the above chart green color shows no value or zero.

Hope it helps you.