I've created a data set that has
Fat Cal's burned
Carb Cals burned
Across heart rate number(s)
Create a line chart with 2 y Axis (Fat & Carb) across the Heartrate data. The only data point I want to print on the line chart is what heart rate level do the 2 y axis' cross?
I'm thinking that I may have to do this 'calculation' off the raw data as an intercept calculation but trying to see if there's another way to have the chart populate the cross over.
Data looks like this:
cho kcal/hr 22.93% 34.07% 38.29% 41.65% 43.39% 67.54% 82.19% 45.57%
fat kcal/hr 77.35% 66.29% 62.10% 58.76% 57.04% 33.07% 18.52% 54.88%
Heart Rate 86.5 98.0 113.1 127.4 140.7 155.3 164.7 107.0
Thanks in advance -
gina
Fat Cal's burned
Carb Cals burned
Across heart rate number(s)
Create a line chart with 2 y Axis (Fat & Carb) across the Heartrate data. The only data point I want to print on the line chart is what heart rate level do the 2 y axis' cross?
I'm thinking that I may have to do this 'calculation' off the raw data as an intercept calculation but trying to see if there's another way to have the chart populate the cross over.
Data looks like this:
cho kcal/hr 22.93% 34.07% 38.29% 41.65% 43.39% 67.54% 82.19% 45.57%
fat kcal/hr 77.35% 66.29% 62.10% 58.76% 57.04% 33.07% 18.52% 54.88%
Heart Rate 86.5 98.0 113.1 127.4 140.7 155.3 164.7 107.0
Thanks in advance -
gina