one line two color chart in excel

eticamorali

New Member
Joined
Aug 27, 2010
Messages
3
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:

Some videos you may like

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
Joined
Aug 27, 2010
Messages
3
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
Joined
Aug 27, 2010
Messages
3
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.
 

Watch MrExcel Video

Forum statistics

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