Display category name and Y value in data label

Is it possible to have the category name along with the Y value in the data label?

On the PWLF1 tab I would like to see Jan along with the value of 9 on the chart in the data label.

Hi Rocky,

you should have a look at the XY Chart Labeller Add-in, download here:
http://www.appspro.com/Utilities/ChartLabeler.htm

The perfect companion for XY charts. You won't want to go without it after you've used it once.

cheers

The add-in creates the labels with VBA and places them on the chart. If you send the file around for viewing, the add-in is not required. If you want to change the labels with the add-in functionality (position, source, adding new data points, etc) then you will need the add-in.

Hi Rocky,

The code for the XY chart labeler is not password protected, so you could copy the forms and modules into the spreadsheet with the chart.

You could run the sub Auto_Open() from the MOpenClose module in the Workbook_Open Event of the file and rund the sub Auto_Close() in the Workbook_BeforeClose event. While the workbook is open, there would be a menu command at the bottom of the tools menu that everybody could use to adjust chart labels.

hth