Using Chart1 I would like to have the $ per head line be green if its OVER the Average and red if its below.
Thanks you for your help
Using Chart1 I would like to have the $ per head line be green if its OVER the Average and red if its below.
Thanks you for your help
Standard approach to conditional formatting in charts is to use a separate data series for each condition, which is mostly about arranging the data in the spreadsheet. Walkthrough here: http://peltiertech.com/conditional-f...-excel-charts/
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks