Total vs partial in a bar chart

Question

How to show won games against total games in a bar chart. I want to show a bar chart with 2 colors indicating total for each team and won games.

Answer 1

Hi Sindhu,

Follow below steps :

1. Select fields total games and game won in row shelf. Now select team name/id and drop it in column shelf.

2. Then two bar chart would be shown similar to this.

3. Now right click on games won and select dual axis. A chart similar to this is created.

You can also switch the axis by clicking on icon shown below.

4. Now you can change color and edit the size of bar for showing games won bar and total bar.

Hope this helps you.