chart only weekdays when data set includes weekends?

[george.coulouris]

I've got a simple table of data:

A B
date1 val1
date2 val2
....
dateN valN

I have several hundred data points, including weekends, but I would
only like to chart the weekdays. Is there a straightforward way to do
this?

Regards,
George Coulouris

 

[Debra Dalgleish]

Jon Peltier has instructions for conditional charts that you could adapt
to your workbook:

http://www.peltiertech.com/Excel/Charts/format.html#CondChart

For example, with dates in column A, use the Weekday function to return
dates for Monday to Friday.

=IF(WEEKDAY($A2,2)>=6,NA(),A2)

 

[george.coulouris]

That did the job!

Thanks,
George