Hi,
Create 2 series and use a stacked cylinder chart. The 2 series should be
based on the original data with one series plotting weekdays and the
other weekends. Use NA() for the weekend value within the weekday series
and the opposite for weekdays in the weekend series.
Cheers
Andy
Seamus Conlon wrote:
I am charting the daily number of support calls that occur
during a month - with days on x-axis and number of calls
on y-axis. I use a standard cylinder chart type.
Is there any way that I can highlight the columns for the
weekend days, to differentiate them for the weekdays,
perhaps with a different colour of cylinder?
Thanks,
Seamus
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info