Tableau Tips : Area Chart With Two Colours




Hi Everybody out there. In todays tip I will show you an effective way of creating an area chart with two colours . Lets go ahead to create an area chart and try to understand what we are trying to achieve.

To create a area chart using the Superstore data , Drag Order Date to columns and from the dropdown select on weeks. Drag Profit to rows twice. This is what you would get :

dualarea1.PNG

Select the first Profit measure and go to edit axis for this . Select fixed and in the Fixed Start enter the value 0.

dualarea2.PNG

Select the second profit measure and go to edit axis. Select the fixed option and in the fixed end enter the value 0.
dualarea3.PNG

You screen should now look somewhat like this:
dualarea4.PNG

Select the color for the first value of measure in the rows to be green and the second value to be red. Unselect show header for both the measure in the row axis and your dual area chart is ready.
dualarea6.PNG

Let me know if you are not able to follow the steps.

 

 




2 Comments

    • Hi Madhu first of all thanks for your time.
      Answering to your question, to apply the colors select the individual measures from the row pane ( where you have two pills of profit side by side ) and change the colors of them individually from the colors mark.

Leave a Reply

Your email address will not be published.


*