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,771
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



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 05:05 PM.


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