Excel 2010 Macro/Networkdays

[gmcgrane]

Hey All
The Response time in this Forum from previous Questions have been excellent and really appreciate the input.

I have attached a Document that I am Working on.
From my previous posts and in this document you will see where I have added the =NETWORDAYS and the problem I have encountered yet again..

(1) I have a new Favor/question in 4 tabs will list all closed tasks can any one help me to create a macro that on command 1st creates a bar chart and as we go on second updates it on command.
Id rather it be on command not running all the time because it tends to crash excel on my pc and slows it down.
Or if there is another way of having the bar chart update without a Macro that would be excellent..
(2) I have had great help From jeffreybrown and others with the =NETWORDAYS but this still does not seem to want to work, I want to have this working on 2 Columns as you can see in the attached any toughts?
(3) Is it possible to not have the True/False appear

[martindwilson]

=networdays?
=networkdays

[gmcgrane]

=networdays?
=networkdays

Sorry I don understand your question?

[martindwilson]

the formula is =networkdays() you have typed =NETWORDAYS(A3,H3,0)

[gmcgrane]

LOL yes I see now I made a Typo thanks I have rectified that now and now that works fine so im closed of on that formula.

Would you be able to assist with
(1) I have a new Favor/question in 4 tabs will list all closed tasks can any one help me to create a macro that on command 1st creates a bar chart and as we go on second updates it on command.
Id rather it be on command not running all the time because it tends to crash excel on my pc and slows it down.
Or if there is another way of having the bar chart update without a Macro that would be excellent..

[martindwilson]

you need to start a new thread with that question in

[gmcgrane]

Thanks Martin I have submitted now