How do you change the color of the line segment within datapoints of a scatter graph line based on "If" statements?
How do you change the color of the line segment within datapoints of a scatter graph line based on "If" statements?
Hello CPITT
welcome to the forums.
You will most likely want to use the NA() Function.
I would create a new area on the worksheet that looks at your original data and then if it matches your criteria then put in the original data. If not, then put in NA(). The #NA result will not be plotted. Then change the color of the lines based on your desired result. Make a new column of data for each color of the line that you want.
Here is a tutorial using NA() function for different colored columns. The same approach can be used for line charts.
How-to Make a Conditional Column Chart in Excel
http://www.exceldashboardtemplates.c...in-excel-redo/
Please let me know if this helped.
Steve=True
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks