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 :
Select the first Profit measure and go to edit axis for this . Select fixed and in the Fixed Start enter the value 0.
Select the second profit measure and go to edit axis. Select the fixed option and in the fixed end enter the value 0.
You screen should now look somewhat like this:
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.
Let me know if you are not able to follow the steps.