Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2015, 12:28 AM
TimTDP TimTDP is offline Format Chart X axis - inconsistent values Windows 7 64bit Format Chart X axis - inconsistent values Office 2010 32bit
Advanced Beginner
Format Chart X axis - inconsistent values
 
Join Date: Apr 2012
Posts: 42
TimTDP is on a distinguished road
Default Format Chart X axis - inconsistent values

I need to create a chart, but the values for the X axis are inconsistent.


The values are date / time based. They are based on when sample readings are taken. So typically they could look like this:

27/11/2015 16:37
28/11/2015 09:00
29/11/2015 09:19
30/11/2015 10:03
01/12/2015 08:04

How can I format / display the X axis to show the readings in correctly spaced time intervals?

Thanks in advance
Reply With Quote
  #2  
Old 12-01-2015, 01:45 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Format Chart X axis - inconsistent values Windows 7 64bit Format Chart X axis - inconsistent values Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post a sample sheet. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 12-01-2015, 02:56 AM
Debaser's Avatar
Debaser Debaser is offline Format Chart X axis - inconsistent values Windows 7 64bit Format Chart X axis - inconsistent values Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

If they are stored as true date/time values and not text, use an XY scatter chart.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rounding values inconsistent required_username Excel 10 06-05-2014 05:35 AM
Color one name on a chart axis angalis428 PowerPoint 2 08-24-2013 09:32 AM
Secondry Axis overlapping in bar chart dual axis in Powerpoint 2010 sharath_ms PowerPoint 0 07-08-2013 10:06 PM
Excel chart with three axis ubns Excel 3 05-15-2012 06:25 PM
how do I add data values in Col A into X axis on bar graph? hazz Excel 1 04-27-2010 01:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft