Legend

A

assaf1978

Hi,
How can I show the legend near every point in the series (in the plot area)
instead of as a list at the side?
 
M

Mike H

Hi,

Right click the series and then

Format data series - Data label tab - Check 'Series Name'

Select and delete the legend at the side of the chart if you don't want it.

Mike
 
A

assaf1978

Thanks, but how do I do this in excel 2007?

Mike H said:
Hi,

Right click the series and then

Format data series - Data label tab - Check 'Series Name'

Select and delete the legend at the side of the chart if you don't want it.

Mike
 
T

Tanya M

Right-click on the series and select "add data labels". Then right-click on
the label itself and select 'format data labels'
 
T

Tanya M

Or... in the Chart Layout tab in the ribbon there is a 'labels' section. Use
the Data Labels drop down to get to the Format Data Labels dialog box. This
will allow you to do all the data series at once.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top