• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

Charting problem - to time series with different frequencies

Hi - I'm struggling with a charting problem; in which I have two number series with different frequencies - and I would like them included in the same chart. The first series has a frequency of 15 min between each data point. The second series has a frequency of 24 hours. By trail-and-error I have tried to chart this, but, I does not work out in an agreeable form. Please review this and see if you can set up a solution for this problem. Thanks! Two-number-series--different-fre.xlsx
0
Utredning
Asked:
Utredning
  • 3
  • 3
  • 2
  • +1
1 Solution
 
Rory ArchibaldCommented:
Not sure if this is what you want, since I don't know what the data is, but if you clear the 'blank' cells in the right hand data series so that they are actually empty, then you can plot on one Y axis and set the chart to interpolate between data points. See attached.
Two-number-series--different-fre.xlsx
0
 
Brian BIndependant Technology ProfessionalCommented:
If you want to show similarity between two plots, but over a different time scale, you could plot the second series on a second X-axis.

Having said that, I just changed the second series in your example to plot on the primary axis and it seems to produce a result that makes sense visually. However that may not be what you are looking for. Try right-clicking the second series and choose Format Data Series. Change the first option to plot on the primary axis.

If that doesn't work, perhaps you could draw what you would like this to look like and attach that?
0
 
andrewssd3Commented:
The reason it's looking odd is that there is something strange about the blank cells in your second series.  They are not really blank, so they are being plotted as 0 on the chart.  I have gone through and deleted each 'blank' cell, and this makes the chart plot much more sensibly.

I have also deleted a huge number of additional cells which were making this file very large - you'll notice that the size has reduced from 8.3MB to 38KB with no loss of content.
Two-number-series--different-fre.xlsx
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
andrewssd3Commented:
You can also move your second series back to the primary axis if you like, which probably gives a more readable chart - there's no difference in scale, so it should not be necessary. Two-number-series--different-fre.xlsx
0
 
UtredningAuthor Commented:
Thank you all for your suggestions. For the record, the numbers are currency crosses.

By the looks of it; its seems that the series with less data points is an interpolation. Is it possible to amend this to 'not interpolate' but rather be shown as a straight line from point to point (as in the first series with high density data plots)?


0
 
Rory ArchibaldCommented:
Yes - just change the chart type for that series from XY with curved lines to XY with straight lines - see attached.
Two-number-series--different-fre.xlsx
0
 
andrewssd3Commented:
I must apologise to rorya - I hadn't read your first post properly and it looks as though I've suggested exactly the same thing
0
 
Rory ArchibaldCommented:
Not to worry - we all do it from time to time. ;)
0
 
UtredningAuthor Commented:
Thanks for your help! I'll hand you the points as you posted your solution before andrewssd3.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now