4 Replies Latest reply: Jul 13, 2011 6:38 PM by crosbyk3 RSS

    Distinguish weekdays and weekends in bar chart

      I've got a stacked bar chart showing sales by region by day for a month. I'd like to be able to show which days are weekends and which are not--I expect the numbers to be lower on weekends, so being able to see dips that are not on a weekend would be helpful.

       

      I tried conditional formatting using the WeekEnd() function but it's not working and I'm not sure if it's the best approach. Any ideas?