Highlighting specific x-axis values
 

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

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

A very good suggestion but I am actually charting the data in a PivotTable
that gets its data from an external database. I then use VBA to set the
source data range etc. Since I can't change the data values in the
PivotTable
I don't see how I can incorporate the NA() function. Any further ideas?

Seamus



"Andy Pope" wrote in message
...
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