Excel 2010 Hourly chart

Posted on 2011-10-13
Medium Priority
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 33

Assisted Solution

by:Paul Sauvé
Paul Sauvé earned 1000 total points
ID: 36964853
Have you tried using Insert>Charts>Scatter rather than Insert>Charts>Line?
LVL 81

Accepted Solution

byundt earned 1000 total points
ID: 36965762
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.

Expert Comment

ID: 36969795
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

ID: 36976617
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 33

Expert Comment

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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

809 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