Dynamically change chart Data Series?

Post Reply
smithbill
Posts: 2
Joined: Mon Jun 18, 2018 9:49 am

Dynamically change chart Data Series?

Post by smithbill »

Hi,

I have a timeseries chart of energy consumption data in WATTS (time on the x-axis and WATTS on the y-axis, chart-type=scatter).

However, it's impossible to view the data in the chart properly as there is a lot of datapoints just a few seconds apart. I'd like to be able to dynamically 'isolate' just a section of the data by 'adjusting' the x-axis start/end points.

For example:

Time Watts
15/06/2018 15:26:19 16
15/06/2018 15:26:21 26
15/06/2018 15:26:26 115
15/06/2018 15:26:27 30
15/06/2018 15:26:29 109
15/06/2018 15:26:30 275
15/06/2018 15:41:59 191
15/06/2018 15:42:20 31
15/06/2018 15:42:30 208
15/06/2018 15:42:31 267
15/06/2018 15:42:36 280
15/06/2018 15:42:55 160
15/06/2018 15:42:56 252 etc etc

Chart Data Series:
Y Values =Sheet1!$C$0:$C$4585
X Values =Sheet1!$A$0:$A$4585

I'd like to be able to change the chart Data Series so that it picks up the cell references to plot from another cell on the chart eg.

Chart Data Series:
Y Values =Sheet1!$C$[$X$0]:$C$[$X$1]
X Values =Sheet1!$A$[$X$0]:$A$[$X$1]

So initially $X$0 = 0 and $X$1 = 4585 and then by changing the values in those two cells, I can change the section of data shown in the chart.

Is there a way to achieve this? Or does anyone know of a program or website where I can effectively 'zoom' into a section of a timeseries data set?

Bill
sven-l
SoftMaker Team
SoftMaker Team
Posts: 6251
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Dynamically change chart Data Series?

Post by sven-l »

You mean like it is shown here (instruction for MS Excel)?
https://support.office.com/en-us/articl ... 70e374f9be

Could you please provide a sample file? Thank you!
Sven Leßmann
SoftMaker Software GmbH
smithbill
Posts: 2
Joined: Mon Jun 18, 2018 9:49 am

Re: Dynamically change chart Data Series?

Post by smithbill »

Hello,

I think I found instructions for creating a 'scrolling' chart in Excel, but when I tried it I don't think its quite what I was looking for.

I've attached a .pmdx spreadsheet which contains a 'run' of energy consumption figures (in WATTs) along with the timestamp when the figure was recorded by the monitor.

The monitor is an Onzo Smart Monitor (introduce to the UK around 2012):
http://www.gadgetreview.com/onzo-smart- ... city-usage
(you can pick these up on eBay now for around £6-10)

As you can see, the data is logged every few seconds, but there is no defined period. It just seems to be a burst of data followed by some random period when nothing is logged or perhaps an occasional value every 5-20mins.

So what I was hoping to be able to do was have a chart which displayed all the data (time on the x-axis, WATTs on the y-axis), but then would allow me to dynamically change the start/end time range on the x-axis (ideally with a slider) so that I could zoom-in or 'focus' on just a section of the dataset (eg. at the WATTs being burned whenever i switch the kettle on! lol)

Bill
Attachments
4-POWER_REAL_FINE.pmdx
(166.27 KiB) Downloaded 374 times
sven-l
SoftMaker Team
SoftMaker Team
Posts: 6251
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Dynamically change chart Data Series?

Post by sven-l »

smithbill wrote: Tue Jun 19, 2018 1:15 pm So what I was hoping to be able to do was have a chart which displayed all the data (time on the x-axis, WATTs on the y-axis), but then would allow me to dynamically change the start/end time range on the x-axis (ideally with a slider) so that I could zoom-in or 'focus' on just a section of the dataset (eg. at the WATTs being burned whenever i switch the kettle on! lol)
That is not possible yet. I will refer this as a suggestion to the product management.
Sven Leßmann
SoftMaker Software GmbH
Post Reply

Return to “PlanMaker 2018 for Windows”