Excel QR Code with Caption

1

Im using the following formula to show specified data from a cell in excel, I want to add Caption below linked to a specific cell in the same row and want to drag the formula down.

My current formula reads as:
=IMAGE(“https://quickchart.io/qr?text=”&N2,N2,3,150,150)

Please assist with:

  1. Adjustment to formula to add the caption (Linked to cell)
  2. Ability to change the Font type and size (eg. Arial, Bold, 14)
2

Any assistance would be greatly appreciated…

3

Hi @CobusD, have a look at the QR code documentation, specifically the caption parameter. You should add caption to the URL.

It would look something like

=IMAGE("https://quickchart.io/qr?text="&N2,N2,3,150,150 & "&caption=" & A2)

(assuming your caption is in A2)