Recreate ithlete rHR/HRV chart?

142

To get the labels, you need to:

  1. Right click on the dot, add Data Label
  2. Right click on the data label, Format Data Labels
  3. Tick the boxes and see which information you want to view, and what not.

image
image

1 Like
143

@Howie : use the simple version, IThlete_chart_v1.5-LocalFileOnly and if the reference to your downloaded file isnā€™t working, paste the three columns in the wellness sheet.
It only has a sheet for wellness and the three needed columns date, hrv, restingHR.
Nothing is column number referenced. The iThlete sheet uses the column headers as named ranges.

144

Is that a Windows version file? Iā€™m on macOS.

145

The simple file @MedTechCD refers to works on Mac, it doesnā€™t have any links to external documents. You copy and paste the data from a manual download and it should work.

1 Like
146

Super. I added ā€œValue from cellsā€ and set the range as ='iThlete HRV'!$B:$B. This creates labels for each dot, but it gets a bit confusing. Is it possible to have the pop-up box as the date label and not the series and point info?

147

The data values being used are not date values, but the X;Y values in columns D&E.

You can show the date in a label, but it will be permanently showing, which results in a cluttered look. Select the date in the ā€œValue from Cellsā€ option.

That is why I have resized the data points to match my understanding of the chart.

Also, the graph is not always correct. Iā€™ve done HIIT when it showed in the Orange and/or Red followed by two days of L2 (Coggan levels) riding. By day 4 I was back in green, and benefitted from the 3 day block.

1 Like
148

Office has no standard way of changing the text on hovering over a chart element. The only way to change that text, is to use ā€˜vbaā€™.
I may do that eventually, but right now, Iā€™m somewhat saturated by all the new programming stuff. Office, Power Query, API, cURL, batch filesā€¦ Iā€™ve done so much stuff that is new to me during the last month, that I need a bit of rest to my mind :wink: .

5 Likes
149

And to be clear, Iā€™m super grateful that you have taken the time to learn all that stuff and made this spreadsheet possible. The label thing is clearly a very, very low priority thought. If anything, eliminating errors and increasing user friendliness are clearly more significant. :call_me_hand:

150

100% Itā€™s just info to be used with all other info to help inform decision making. :+1:

1 Like
151

So Iā€™ve been playing around with the Google Sheets version over the weekend - this works better for me as you can refresh data via the web version which I donā€™t think it possible with the Excel Power Query version. There doesnā€™t seem to be a way to colour the zones, so I have had to stick to colouring and changing the shape of the points.

I have made other tweaks for my own use, but can share if it helps.

Capture
Capture912Ɨ658 14.4 KB

5 Likes
152

Welcome to the ā€œDev teamā€ā€¦ your assistance will be appreciated

2 Likes
153

:joy: thanks

Here is a copy of the Spreadsheet I modified. Athlete ID and API Key need to be entered into cells the HRV_calc sheet (personally then hide this sheet). I removed the refresh/update button as I had set the script to run whenever the sheet is opened. You can manually refresh the data by going Extensions/Macros/importIntervalsICU.

Planned to use this mainly on mobile, therefore the chart to its own tab and formatted a summary info ā€œpageā€ giving today and yesterdays results.

Not taking any credit for this, as Iā€™ve simply modified the Excel and GS provided by others to meet my own needs.

8 Likes
154

Good job! :+1:
Looks like a really nice start. Sync worked right away.
Hopefully someone is able to improve the graph.

155

I would love to get access !

156

Thanks, credit is where credit is due.

Isnā€™t that the objective of ā€œopen sourceā€ stuff? To let collaborators help to improve it.

3 Likes
157

The Google sheet link above is active for everyone. Just save your own copy of it and work your magic :wink:
Make sure to share your work!

2 Likes
158

Super cool. So easy. Thanks!
Two edits I made for readabilty:

  1. Change the date format on ā€˜HRV_calcā€™:
    =IF(ISBLANK(Wellness!$B4),NA(),CONCATENATE(MONTH(Wellness!$B4),"/",DAY(Wellness!$B4)))

  2. Add custom labels to Data series 6, 10, 11 & 13 on ā€˜HRV Guideā€™ in order to see the dates:
    HRV_calc!AA4:AA60

1 Like
159

This is giving me a ā€˜view onlyā€™ option on mobile. Wonā€™t let me edit to input athlete id or API?

160

Save your own copy!

3 Likes
161

As MedTechCD has said, save a copy. If everyone uses the same file you wonā€™t get meaningful info as it will change.

1 Like