ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Legend (https://www.excelbanter.com/excel-discussion-misc-queries/208757-legend.html)

assaf1978

Legend
 
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?

Mike H

Legend
 
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

"assaf1978" wrote:

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?


assaf1978

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

"Mike H" wrote:

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

"assaf1978" wrote:

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?


Mike H

Legend
 
No idea I haven't used it

"assaf1978" wrote:

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

"Mike H" wrote:

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

"assaf1978" wrote:

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?


Tanya M

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

"Mike H" wrote:

No idea I haven't used it

"assaf1978" wrote:

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

"Mike H" wrote:

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

"assaf1978" wrote:

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?


Tanya M

Legend
 
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.

"Mike H" wrote:

No idea I haven't used it

"assaf1978" wrote:

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

"Mike H" wrote:

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

"assaf1978" wrote:

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?



All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com