Thread
:
chart only weekdays when data set includes weekends?
View Single Post
#
2
Debra Dalgleish
Posts: n/a
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
Reply With Quote