#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Like this?
I changed type to XY Scatter, added lines between points. For X-axis, I set Number category to Time, and set Major Units to 0.25. |
#3
|
||||
|
||||
Are you still using XL2003 as stated in your profile? If not, amend it as required as helpers will tailor answers to your XL version
__________________
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 |
#4
|
|||
|
|||
Quote:
Quote:
|
#5
|
|||
|
|||
activate Chart, and double-click. Format Chart Area window activates at right. Click on any point of Data Serie on graph - Format Data Series window is activated. Set Line to 'Solid line'.
|
Tags |
graph, time |
Thread Tools | |
Display Modes | |
|
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 |