Column Graph Question

[mholton63]

I have a manual column graph under a line graph. I'd like each column to be green until in gets above my goal, then I want it red. Is this possible. Or would it be better to do this in a VBA?
See example below

 

[ekrause]

Yes it can be done. I whipped this up very quickly.

You need to add a new table with some logic to look at your Daily numbers vs Goal.

This is the logic I used for Daily Under Cells =IF(B3>=B2,0,B3)
This is the logic I used for Daily Over Cells =IF(B3>=B2,B3)

	a	b	c	d	e	f
1		31	1	2	3	4...
2	Goal	12307	12307	12307	12307	12307
3	Daily	10500	9973	10275
4	MTD	10500	10237
5		31	1	2	3	4
6	Daily Under Logic	Formula goes here
7	Daily Over Logic	Formula goes here
8	Goal
9	MTD

Select the Table -> Insert -> Stacked Column
Then right click on one of the columns in the the graph and select "Change Series Chart Type", see below
Change Goal & MTD to Chart Type = Line, see below
Change colors as desired

 

[mholton63]

Yes it can be done. I whipped this up very quickly.

View attachment 78786

You need to add a new table with some logic to look at your Daily numbers vs Goal.

This is the logic I used for Daily Under Cells =IF(B3>=B2,0,B3)
This is the logic I used for Daily Over Cells =IF(B3>=B2,B3)

	a	b	c	d	e	f
1		31	1	2	3	4...
2	Goal	12307	12307	12307	12307	12307
3	Daily	10500	9973	10275
4	MTD	10500	10237
5		31	1	2	3	4
6	Daily Under Logic	Formula goes here
7	Daily Over Logic	Formula goes here
8	Goal
9	MTD

Select the Table -> Insert -> Stacked Column
Then right click on one of the columns in the the graph and select "Change Series Chart Type", see below
Change Goal & MTD to Chart Type = Line, see below
Change colors as desired

View attachment 78787


View attachment 78788

This will work. Thanks for the help