Show Data Labels On Bars Of Bar Chart

Hi all,

I would like my y-axis labels to appear on the bar chart intead of next to the chart
Is this possible through chart/axis settings or do I need to manually add text box to each bar and set each text box = the appropriate cell?

The chart is attached
Thanks
Regards,
marc

Re: Show Data Labels On Bars Of Bar Chart

Thanks all,

Dave,
Could you expand a bit?
I tried dragging the vertical value axis to the bar chart, had no impact
Was there somthing else I was to drag n' drop?

Junho,

Thanks. I am trying to make the value axis appear as overlaid on the bar chart as opposed to immediately to the left of the bar chart

Daniel,

Looks good, except lost the data value labels.
Can I have both using this method?

Edit:
I walked through the steps you provided
They were a little different for xl 2007, but very close

For label options I chose Category Name and Value.
For label position, I chose Inside Base

This yields the category name.. a comma.. category value
Is it possible to have the label inside base but the category value to the right end of each bar?

Thanks all!
Regards,
marc

Re: Show Data Labels On Bars Of Bar Chart

Thanks all,

Andy,

That worked great!:music:

Thanks
Regards,
marc