• ## Excel - Charts and Data Visualization

### Temperature Forecast Chart

by Published on 2013-03-20 05:04 AM     Number of Views: 30111

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

#### Number of consecutive cells in a row

Optional response to your true meaning : =(MAX(IF(B1:F1>0,COLUMN(B1:F1),"")))- COUNTIF(B1:F1,0)...

Roger Haney Yesterday, 08:55 PM

#### Number of consecutive cells in a row

If I understand you correctly, then this formula will work : =(MAX(IF(B1:F1>0,COLUMN(B1:F1),"")))-1. The " -1 " at the end of the...

Roger Haney Yesterday, 08:30 PM

#### Tracking numbers in a row & counting them in columns

Try this one in I5 copied across and down:

=SUMPRODUCT(COUNTIF(\$H5:\$K5,S\$5:S\$13))

=MAX(range) simply finds the...

AliGW Yesterday, 05:32 PM

#### Tracking numbers in a row & counting them in columns

Ali what you did was perfect and brilliant and I have a use for those numbers in that order.

How would the formula be different if my numbers...

ExcelHelpNeeded Yesterday, 04:51 PM

#### Tracking numbers in a row & counting them in columns

That is brilliant! I was making this soooo much more complicated. I have never used or even seen the &MIN and &MAX though. Can you explain how...

ExcelHelpNeeded Yesterday, 03:34 PM