• ## Excel - Charts and Data Visualization

### Temperature Forecast Chart

by Published on 2013-03-20 06:04 AM     Number of Views: 23593

Some of the really cool charts that we can build in Excel involve the trick of combining multiple chart types together to make them happen. In this article, we’ll build one of those; a temperature chart that not only shows the forecasted high and low temperatures, but also the season highs and lows. The beauty of this chart is that it provides a lot of information, some of which essentially fades into the background until you really need it.
...
• ### Recent Forum Posts

#### Excel - Data Validation syntax

Correct!...

Steve-SDC Today, 01:26 AM

#### Excel - Data Validation syntax

I don't think that data validation in cell K25 (what you asked for) will do anything, so I'm guessing you've put that data validation in other cells ...

p45cal Yesterday, 10:56 PM

#### Excel - Data Validation syntax

Thanks for your response! A User (Sergio) within another forum provided me with a very good solution, allowing me to apply it within 'Data Validation'...

Steve-SDC Yesterday, 08:43 PM

#### Excel - Data Validation syntax

You can't do data validation on the result of a formula. However you can do something along the lines of:[CODE]=IF((J22*K24)+1...

p45cal Yesterday, 07:20 PM

#### Excel Count Unique cells with given criteria

Test this one thoroughly; I haven't:

Code:
=SUMPRODUCT(--(RIGHT(A1:F6,2)="AA"),MMULT(--(ISODD(ROW(A1:F6))),--(ISODD(COLUMN(A1:F6)))),1/COUNTIF(A1:F6,A1:F6))
...

p45cal Yesterday, 06:35 PM