chart only weekdays when data set includes weekends?
 

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

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

http://www.peltiertech.com/Excel/Cha...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)

wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

That did the job!

Thanks,
George