Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-04-2022, 09:15 PM
gib65 gib65 is offline How can I plot data points on time axis proportionally to time scale? Windows 10 How can I plot data points on time axis proportionally to time scale? Office 2003
Advanced Beginner
How can I plot data points on time axis proportionally to time scale?
 
Join Date: Aug 2010
Posts: 84
gib65 is on a distinguished road
Default How can I plot data points on time axis proportionally to time scale?

Hello,

I have a graph that plots time against "levels" (see attachment).

On the time axis, it spaces the data points apart by the same amount regardless of their value. For example, as you can see in the attached spreadsheet, the data points at 5:30 and 11:15 are spaced apart by the same amount as the data points at 11:15 and 12:00 even though the first is a 5 hours and 45 minute difference and the second is only a 45 minute difference.



What I would like to do is space the data points apart in proportion to the difference in the values. In other words, the first and second data points should be almost 8 times the distance apart as the second and third data points.

How can I get Excel to space out the data points in proportion to the difference in the values?

Thanks.
Attached Files
File Type: xlsx example.xlsx (16.0 KB, 8 views)
Reply With Quote
 

Tags
graph, time



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I do an animation with the bullet points where only one point is visible at a time? needHelpwithPP PowerPoint 5 09-13-2021 04:55 PM
Scatter Plot X Axis Naming Convention constructionjasont Excel 1 09-13-2017 02:49 AM
Excel 2016 line chart shows 2 erroneous (zero) data points in x axis. How to remove them? 5434aw Excel 4 07-31-2016 07:54 AM
Proportionally spread dates on chart x-axis? jhoby Excel 0 06-07-2015 01:04 PM
Scatter plot with only second y axis hanvyj Excel 0 07-26-2012 03:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:18 AM.


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