Excel 2010 Hourly chart

Posted on 2011-10-13
Last Modified: 2012-05-12
The chart is made using Insert>Charts>Line>2D (any)
There are only 2 columns in the source
The first column contains each hour within a month, i.e. "13/06/2011 01:00" (data type = datetime)
The second column contains a number

The resultant chart coalesces around the date, i.e. all data points appear on a date; there are no points between dates.

Question: How do I get the data to appear hourly?
Question by:cyberkiwi
    LVL 30

    Assisted Solution

    by:Paul Sauvé
    Have you tried using Insert>Charts>Scatter rather than Insert>Charts>Line?
    LVL 80

    Accepted Solution

    If you have all of the hours within the month, you might consider changing the axis to Text instead of Date. In so doing, you will display data every hour without coalescing.
    LVL 9

    Expert Comment

    Are you attempting to build a 2D chart with 24 * 30 days(720) points
    and need to auto update every hour on the hour, for current month to-date?
    LVL 58

    Author Closing Comment

    I tried Paul's solution as soon as it was presented, and indeed all data points faithfully appeared. But the X-axis just doesn't look right.
    Given I had all the hours, Brad's was what I used (well before seeing the solution).

    What really irks me is why Excel would even consider coalescing data instead of presenting "as-is" for hourly values.

    Thanks Paul and Brad for your time and assistance.

    @experts1 - no, but thanks for your comment.
    LVL 30

    Expert Comment

    by:Paul Sauvé
    @ cyberkiwi - glad everything worked out OK!

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    This collection of functions covers all the normal rounding methods of just about any numeric value.
    In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now