color line based on difference increase decrease

Question

How to show color in a line chart to show profit increase or decrease depending on avg profit? Show red if decreased and green if increased.

Answer 1

Hi Sindhu,

Once you create a line graph, Drop the profit over the color shelf.

Now Right click on the profit column and add quick calculation as difference.

Now the graph would change as below,

Click on the color legend on the right and edit color as red-green to get red-green color in the line graph.

Hope it helps!.