Creating a even time axis in Excel when you have a uneven time values Step by step (translated from German version, XL2003): 1 Select your x,y data 2 "Insert" "Diagram" 3 Choose "Line diagram" (as an example) 5 For "primary axis", choose "time axis" 6 Finish You can even format the time axis later on to only show months, and adjust the starting and ending point in time I follow you to step 3
Chart with X-axis showing different intervals of time When I plot the data on a line graph with a date time axis, this happens: The Graph automatically inserts the missing years (the shaded blue area), scrunching up the remaining data on the far right My task was to figure out a way to remove the inserted years The graph shown is on a date time scale
An uneven time-increment - Excel Help Forum There are two ways, both involving the use of a time scale axis Method 1 In the worksheet, change the years to dates like the first of each year, or 1 1 1985, 1 1 1986 Then recreate the chart Excel is likely to generate a time-scale axis without human
How do I get a chart to work with irregular dates correctly? I've tried for some time now to create a chart where the x-axis make up for irregular dates Making the line between 2 points longer if it's long time between them and short if it's short time between them I've finally understood line charts doesn't support that and I have to use scatter graph
Regular ticks for X-axis when data is irregular What I'd like is a chart with an X-axis where the horizontal distance is constant for constant time periods So, for example, I'd like to have a tick for the first day of each month, with the Value data blank during periods when it doesn't exist
Time series plotting with irregular custom dates and times using - Microsoft Community But I'm having problems using Excel 365 scatterplots for time series Specifically, the x-axis defaults to a numeric value and changing the axis to Date returns a series starting 01 01 1900 indicating that "Excel is assuming" the data is categorical and assigning
Time series chart with irregular interval - Excel Help Forum The simplest way around this is to leave the x axis labels to scale automatically and add the years as labels to the data points in the graph If you particularly need the years on the x axis, you could try a workaround of creating a dummy series with a value of 0 at each data point and then adding data labels to this series and setting the
Plot data with different time readings on same plot I have made a small example table below, but want to do this to combine 20 sets of measurements in the same graph For the example below i want a x-axis ranging from 01 01 18 to 05 01 23 so all the "values" can be plotted at the corresponding date on the y-axis