• Excel - Charts and Data Visualization

    by Published on 2013-03-20 05:04 AM     Number of Views: 27988 
    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

    hbgurley

    Help With SumIfs

    Your formula in column O3 was very close. The problem was that your named ranges were different lengths. WeekNo went from A2:A69 while Worker and TimeTaken...

    hbgurley Today, 08:53 PM Go to last post
    Ken Puls

    Acess data in shared onedrive file

    Hi Sam,

    When you open the file, what gets returned if you go to File -> Info -> Copy Path?

    Paste that in a cell. I can't...

    Ken Puls Today, 07:29 PM Go to last post
    Ken Puls

    Power Query returning Excel functions

    Hi jmlee,

    It's entirely possible to create formulas in Power Query, but you have to learn the M syntax, which is quite different than Excel's...

    Ken Puls Today, 07:14 PM Go to last post
    sjo007

    Conditional Formatting based on a criteria

    I have a row of values and a Standard Deviation calculation at the end of each row. I have a cell on the same sheet with an SD number in.

    ...

    sjo007 Today, 03:56 PM Go to last post
    Currymonster30

    Help With SumIfs

    Hi I wonder if anyone can help as Iím not an excel expert and am stuck.
    Iíve entered some dummy data into my workbook to test it but canít figure...

    Currymonster30 Today, 03:31 PM Go to last post