ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I add a series name to a legend on a graph? (https://www.excelbanter.com/charts-charting-excel/262417-how-can-i-add-series-name-legend-graph.html)

John Nollett[_2_]

How can I add a series name to a legend on a graph?
 
I have a series of Doughnut charts and would like to add a Series Name in the
centre of each one, how can I do this?

trip_to_tokyo[_3_]

How can I add a series name to a legend on a graph?
 
EXCEL 2007

Try the following:-

1. Click in (one of) the doughnut ring(s).

2. Chart Tools / Layout / Labels group / Data Labels / More Data Label
Options . . . / Format Data Label window should launch with Label Options
highlighted in orange on the left hand side / place a tick (check) in
Category Name on the right hand side / Close

I think the above will give you what you want.

If you agree please hit Yes.

Thanks.



"John Nollett" wrote:

I have a series of Doughnut charts and would like to add a Series Name in the
centre of each one, how can I do this?



All times are GMT +1. The time now is 12:17 AM.

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