Excel plot time series frequency with continuous xaxis

0 votes
A time series of frequency data like the one below is what I want to plot. I tried a variety of charts, but they all placed the time (8:00) precisely within the data series column. I also tried typing 8-9, 9-10, and 10-11, but that just looks terrible because time series must be continuous. The data series should start and conclude at 8:00 and 18:00, respectively, and should fall within the intervals of 8-9-10-11, etc. Any recommendations?
Nov 7 in Others by Kithuzzz
• 20,660 points
22 views

1 answer to this question.

0 votes

Excel has a few oddities that must be worked with in order to produce good Time Series graphs in the way you like.

  • Make certain to choose "Scatter Graph" (with a line option). This is required if your time stamps are not uniform, and it will scale the X-axis appropriately.
  • You must include a column with the midpoint in your data. What I did with your sample data is shown here. (This method makes that the data is plotted at the desired midpoint.)
  • enter image description here
  • You can format the x-axis options with this menu. (Chart->Design->Layoutenter image description here
  • Select "Axes" go to Primary Horizontal Axis, and then select "More Primary Horizontal Axis Options"
  • Set up the options you wish. (Fix the starting and ending points.) enter image description here
  • And you will get a graph such as the one below. enter image description here

You can then tweak many of the options, label the axes better, etc, but this should get you started.

answered Nov 7 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
0 answers

Download Excel sheet from .NET Core 3.1 Web API with jQuery Ajax client

I am trying to download an Excel ...READ MORE

Feb 10 in Others by Edureka
• 13,640 points
365 views
0 votes
0 answers

Excel: Highlighting duplicates with exact matches

1 I've got two columns of data, and ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
54 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
101 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

Feb 18 in Others by Edureka
• 13,640 points
74 views
0 votes
1 answer

Save a plot as image on the disk using R

Consider for both the situations: 1. Image will ...READ MORE

answered Apr 14, 2018 in Data Analytics by Sahiti
• 6,380 points
1,317 views
0 votes
1 answer

Plot two variables as lines on the same graph using ggplot

If you have small number of variables, ...READ MORE

answered Apr 17, 2018 in Data Analytics by kappa3010
• 2,090 points
3,963 views
0 votes
1 answer

R lag irregular time series data

You could try using: library(dplyr) library(zoo) na.locf(ts$value[sapply(ts$time, function(x) min(which(ts$time - ...READ MORE

answered May 11, 2018 in Data Analytics by Sahiti
• 6,380 points
559 views
0 votes
1 answer

R plot arima fitted model with the original series

This question has many ways to answer, ...READ MORE

answered May 19, 2018 in Data Analytics by DataKing99
• 8,240 points
3,516 views
0 votes
1 answer

Excel plot against a date time x series [closed]

Try using an X-Y Scatter graph with ...READ MORE

answered Oct 22 in Others by narikkadan
• 37,660 points
20 views
0 votes
1 answer

Reading/parsing Excel (xls) files with Python

I highly recommend xlrd for reading .xls files. But there are ...READ MORE

answered Sep 21 in Others by narikkadan
• 37,660 points
61 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP