How to change line graph color when it is increasing and decreasing

**Juntann** · 07-28-2018, 06:35 AM

Hi Everyone,

Is there a way to change the color of a single line chart when it is increasing in value and decreasing in value?

For example a value of 1 to 5 will be a color green line then it goes down to 5 to 4 the color will be red

graph.png

Thanks in advance

**MrShorty** · 07-28-2018, 10:27 AM

Standard answer to conditional formatting in a chart is to add different data series for each format that you want, so that most of the work is in the spreadsheet. Review tutorial here: https://peltiertech.com/conditional-...-excel-charts/

How to change line graph color when it is increasing and decreasing

LinkBack

Thread Tools

Rate This Thread

Display

How to change line graph color when it is increasing and decreasing

Re: How to change line graph color when it is increasing and decreasing

Thread Information

Users Browsing this Thread

Similar Threads

Change the color of each high-low line in graph

[SOLVED] need help-increasing/decreasing

Change the line color in a graph

Change color of line in line graph

Changing the color along a row to show increasing and decreasing values

increasing/decreasing by one

increasing/decreasing; decreasing rate - problem

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions