13 Replies Latest reply on Mar 13, 2015 9:11 AM by Shawn Wallwork

    Color scale with more than one measure

    John Forr

      We have an activity with a start and end time.  I'm trying to show the average duration of each activity's time, but in the special case that an activity has started, but not finished, I also want to convey that fact.

       

      I'd like to setup a chart where each dimension has a red-green diverging mark based on an average of duration.  If the activity has a start time, but no end time, then I'd like to color the mark a third color.  Any ideas on how to do this?

       

      Message was edited by: John Forr Attached Workbook