Data labels

Hi Keith

Thank you for your question and welcome to the forum.

Assuming you have the raw data stored in a datasheet for the chart, I think it will depend on where the data is positioned in the data sheet.

If you like, you can email through a copy of the slide to me and I'll have a look at it and see if I can get the data label coming up for you. Email address is amanda@stl-training.co.uk

Kind regards
Amanda

Hi Keith

Thanks for sending a sample slide through.

I've changed it around so that the labels show next to each bar, which is my understanding of what you wanted to achieve - see attached.

If you double-click on the chart and look at the sheet with the data, you will see how I have rearranged the data in rows rather than columns.

To do this I needed to convert the data range from being a list to a normal range (right click, select List then Convert to Range).

Then I cut the data and used Paste Special to transpose it from columns to rows.

Then I changed the data range for the chart - go to the sheet containing the chart and double click on it, then go to Chart - Source data and reselect the data range and click OK.

To get the data labels coming up, go to Chart - Chart Options - Data Labels and tick the Series box and click OK.

I hope this helps.
Amanda