ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I place the legend next to the data point on a chart? (https://www.excelbanter.com/charts-charting-excel/145658-how-can-i-place-legend-next-data-point-chart.html)

LW52

How can I place the legend next to the data point on a chart?
 
In Excel 2003 there was an place the legend next to a data point. I just
upgraded to Office 2007 and can not find this option.

Andy Pope

How can I place the legend next to the data point on a chart?
 
Hi,

Select the data labels and right click. Format Data Labels to bring up the
Format dialog.
Select Label Options in the list.
The 3rd section has the checkbox 'Include legend key in label'

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"LW52" wrote in message
...
In Excel 2003 there was an place the legend next to a data point. I just
upgraded to Office 2007 and can not find this option.




All times are GMT +1. The time now is 04:40 PM.

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