• Excel - Charts and Data Visualization

Temperature Forecast Chart

by Published on 2013-03-21 05:04 AM     Number of Views: 21024

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

How to return and sum columns based on criteria/s

[QUOTE=NBVC;37076]Assuming the aquisition date is 1st of the month, try:

[COLOR=#0000ff]=SUMIFS(STRAIGHTLINE!\$D\$6:\$D\$8,STRAIGHTLINE!\$I\$6:\$I\$8,">0",STRAIGHTLINE!\$E\$6:\$E\$8,"0",STRAIGHTLINE!\$E\$6:\$E\$8,"0",STRAIGHTLINE!\$B\$7:\$B\$401,"Totals")-SUMIFS(STRAIGHTLINE!\$I\$7:\$I\$401,STRAIGHTLINE!\$B\$7:\$B\$401,"Totals")+SUMPRODUCT((STRAIGHTLINE!\$K\$7:\$K\$401:INDEX(STRAIGHTLINE!\$K\$7:\$V\$401,,MATCH(SUMMARY!\$E\$2,STRAIGHTLINE!\$K\$4:\$V\$4,0)))*(STRAIGHTLINE!\$B\$7:\$B\$401"Totals"))+STRAIGHTLINE!Z6...

nmmnyr Today, 12:37 AM

Categorizing based on multiple conditions & criteria containing text

Yes, I realized it was just a combination of the two different type of statements above as you also stated here. Thanks again, this was a huge help!...

AnnaB Yesterday, 10:25 PM

Need help with the diagram

I need this data in a diagram

something like this

Its very important that the percent value is the visual diagram and the 3rd...

J0hNTH3P4P7T0 Yesterday, 08:14 PM

Categorizing based on multiple conditions & criteria containing text

Do you mean?

=IF(A2="","",IF(OR(ISNUMBER(SEARCH({"X","Y"},A2))),"Category1",IF(OR(ISNUMBER(SEARCH({"A","B","C"},A2))),"Category2",IF(OR(ISNUMBER(SEARCH({"M","N"},A2))),"Category3","Other"))))...

NBVC Yesterday, 06:38 PM

Categorizing based on multiple conditions & criteria containing text

Actually, I do have one more follow up questions. How would you recommend I go about blanks vs. "other". I see you have an else ""...

AnnaB Yesterday, 05:33 PM