Excel chart data lines extending through the x and y axis.

Question

Hi,

I just can't seem to find an answer for this issue. I am preparing a chart and there are certain data points within my chart that I would like to extend through both of the axis. Ideally, I would like to be able to pick an individual data point and assign a label (name such as pK) and then have the point draw lines back to each axis to show where that line intersects on that axis.

I have included a screen capture that I hope will more adequately convey what I am after.

Thanks in advance,

Gordon.

Answer 1

Hello,

these lines can be added with error bars. Consider the following screenshot.

Error bars are set to Minus, no cap and custom values.

The custom value ranges point to columns on the spreadsheet. In this scenario, the formula in F1 is

=IF($C3="pk",D3,0)

copied across and down.  To turn error bars on for a particular data point, find its row in the data source and enter the text "pk" (without quotes) into the respective cell in column C.

You can also enable data labels for the series, select the option to use "Values from cells" and select C3 to C7 in this scenario. Then pK will show as the data label if it is typed into column C.

Answer 2

Hello Teylyn,

Thanks for your prompt response. I seem to be making a hash of this rather quickly. I'll fiddle around with the code a bit more. I just wanted to thank you for your advice.

Regards,

Gordon.

Answer 3

Perhaps you should even learn something useful about the evaluation of titration curves. Look at:

http://people.stfx.ca/bliengme/ExcelTips/Titration.htm

PB