chart only weekdays when data set includes weekends?

's Computer Specifications

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

's Computer Specifications

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)

(E-Mail Removed) 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

's Computer Specifications

That did the job!

Thanks,
George

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
WEEKENDS VS. WEEKDAYS	=?Utf-8?B?VExBbmdlbG8=?=	Microsoft Excel Misc	0	10th Jul 2006 06:49 PM
WEEKENDS VS. WEEKDAYS	=?Utf-8?B?VExBbmdlbG8=?=	Microsoft Excel Misc	7	12th May 2006 05:31 PM
IF statement with Weekends vs. weekdays	edwardpestian	Microsoft Excel Worksheet Functions	4	7th May 2006 09:13 PM
How do I print weekends the same size as weekdays?	=?Utf-8?B?TW8=?=	Microsoft Outlook Calendar	1	25th Oct 2005 05:08 AM
counting only weekdays not weekends	Joyce	Microsoft Access VBA Modules	2	29th Jan 2004 10:58 PM