# one line two color chart in excel

#### eticamorali

##### New Member
Here is what I am trying to do:

I need to have a graph that has number of squares completed on the y axis, the week beginning on the x axis. Now here's my dilemma. I need to have a goal line grow constantly with each week AND to have my productivity line change colors if the production drops below the goal.

Also, if anyone knows how to integrate a % complete progress bar chart into this as well that would be greatly appreciated.

Here is sample info:

Week Squares produced Goal (they get bigger by 2.58 for each week)
8/2/2010 0 2.58
8/9/2010 2.51 5.16
8/16/2010 0 7.74
8/23/2010 2.51 10.32

With this example you can see that we are below the goal of 10.32 if you add up the (2) 2.51's....so I would want that one color.....and if we exceed the goal than I want that part of the line another color.

and so on.....

Any help would be greatly appreciated.

Last edited:

### Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

#### eticamorali

##### New Member
Thanks but I have been to that site and can't make heads or tails of it. Can anyone simplify it for me. I am pretty good at excel but this is puzzling me.

#### eticamorali

##### New Member
Here is what I am trying to do:

I need to have a graph that has number of squares completed on the y axis, the week beginning on the x axis. Now here's my dilemma. I need to have a goal line grow constantly with each week AND to have my productivity line change colors if the production drops below the goal.

Also, if anyone knows how to integrate a % complete progress bar chart into this as well that would be greatly appreciated.

Here is sample info:

Week Squares produced Goal (they get bigger by 2.58 for each week)
8/2/2010 ---0--- 2.58
8/9/2010 ---2.51--- 5.16
8/16/2010---- 0 ----7.74
8/23/2010 ----2.51-----10.32

With this example you can see that we are below the goal of 10.32 if you add up the (2) 2.51's....so I would want that one color.....and if we exceed the goal than I want that part of the line another color.

and so on.....

Any help would be greatly appreciated.

the formatting on this posting had originally grouped all my numbers together, so I put dashes in between so it's easier to read.

Replies
0
Views
311
Replies
16
Views
189
Replies
0
Views
283
Replies
1
Views
223
Replies
4
Views
158

Threads
1,118,876
Messages
5,574,765
Members
412,617
Latest member
mlharris