Showing alternate Data Labels

[gargoil666uk]

I have a sheet that records batches of wine.
Values arranged in columns, with column C having “Sugar Used”, with column G being final “ABV%”.
I also have column A recording a “Batch Number”.

I have inserted a Column type bar chart with data ranges thus:
x-axis = Sugar Used, Categories = $‘Wine Making Timetable Calculator’.$C$8:$C$40
y-axis = ABV%, Range for y-Values = $‘Wine Making Timetable Calculator’.$G$8:$G$40

When using data labels I see the y-Values, obviously.
However, ideally I would like to show the Batch Number from column A, above the y-Values .
How can this be achieved, if at all possible?

Thanks
winemaking_specific_gravity_versus_sugar_volumes.ods (25.4 KB)

[erAck]

Best attach a sample document so we don’t have to guess around and recreate what exactly you have already. Edit your question (... three dots and pen) and use the Upload icon.

[gargoil666uk]

See attached document. I hope my earlier explanation makes sense.
Ignore the obvious erroneous IF and NA() functions in the lower columns.

[Lupp]

I can’t imagine a way to place the batch information where a data label is expected. You can, however, enhance the labelling of the horizontal axis to get the batch shown there.
See attached example.
enhancedChartAxisLabels.ods (56.0 KB)

[gargoil666uk]

Okay, thanks. I had considered that approach for the horizontal axis, but I was hoping that perhaps there was a data label alternative.

[Lupp]

I feel sure an alternative of the kind you would prefer is not implemented. To create one based on user code isn’t impossible, but complicated, and all the time you would take for it, would probably not pay in a slightly different case you didn’t prepare for.