Can both the x and y axes display values?

[lgb]

I understand that the default chart setup in Excel is for
the y-axis to display relative values and the x-axis to
display categories (often time periods). I want, though,
to have both axes display values. Specifically, I want
the x-axis to be increments of lactate acid levels and
the y-axis to be increments of heart rate. I want to
plot a single line that connects points that are
intersections of a specific lactic acid level and a
specific heart rate. Can I do this and, if so, how do I
do this?

Thank you in advance.

 

[Andy Pope]

Hi,

Use the xy scatter chart type. It has a sub type that creates markers
connect with a line.

You data is best stored in 2 columns, xaxis and the yaxis data.

Cheers
Andy