• Excel - Charts and Data Visualization

    by Published on 2013-03-20 06:04 AM     Number of Views: 29196 
    Article Preview

    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.
    ...
  • MVP Logo
  • Recent Forum Posts

    Bob Phillips

    Index/match with multiple match criteria

    When I said Q1, I meant Quarter 1, cell E31, not cell Q1.

    It most definitely does match your last upload, C8:C30 is the date which I parse,...

    Bob Phillips Yesterday, 06:44 PM Go to last post
    GLewis14

    Consolidate paired data sets

    hi all,

    I have a sheet which contains data sets (3 rows per data set), see Product Level sheet of attachment. I want to consolidate and total...

    GLewis14 Yesterday, 02:46 PM Go to last post
    alansidman

    Please help!

    What is the criteria for counting the quantity. Would be helpful if you provided a sample workbook showing what you have and what your expected results...

    alansidman Yesterday, 06:21 AM Go to last post
    cprop76

    Please help!

    I am trying to count two separate pieces of data which appear in the same excel column. The columns will have a date followed by a quantity so look something...

    cprop76 Yesterday, 05:52 AM Go to last post
    anon125

    does excel 2002 have page layout>themes and colors

    using a great vertex spreadsheet, but to change the colours it says to use page layout>themes and page layout>colors
    I assume my old version...

    anon125 Yesterday, 01:38 AM Go to last post