Thread: Charts and if statements

Is it possible to do a chart that incorporates if statements.

Lets say I have:

row A = dates
row B = a number

A1 = 06/01/2006 B1 = 0
A2 = 07/01/2006 B2 = 10
A3 = 08/01/2006 B3 = 3
A4 = 09/01/2006 B4 = 1
A5 = 10/01/2006 B5 = 0
A6 = 11/01/2006 B6 = 0

What I am trying to do is have a chart that will only show that data has a date that is earlier that Today(). So it will not chart A4, A5, & A6. But as the date changes it will change what it charts.

I also want it in two versions:

1. that charts a 3month history
2. that charts all historical data.

Anyone know how to do this?

insert a column between A & B and put following function in new col (that will be B now)
=IF(A1<TODAY(),A1,"")
and use this new column for charting instead of column A (you can hide this new column after refering to chart)
whenever you put new data or edit an existing data new col will automatically be changed and resultantly your chart.

hopefully this would help you.

Originally Posted by jermsalerms

Is it possible to do a chart that incorporates if statements.

Lets say I have:

row A = dates
row B = a number

A1 = 06/01/2006 B1 = 0
A2 = 07/01/2006 B2 = 10
A3 = 08/01/2006 B3 = 3
A4 = 09/01/2006 B4 = 1
A5 = 10/01/2006 B5 = 0
A6 = 11/01/2006 B6 = 0

What I am trying to do is have a chart that will only show that data has a date that is earlier that Today(). So it will not chart A4, A5, & A6. But as the date changes it will change what it charts.

I also want it in two versions:

1. that charts a 3month history
2. that charts all historical data.

Anyone know how to do this?