{"id":1939,"date":"2022-08-07T09:56:30","date_gmt":"2022-08-07T06:56:30","guid":{"rendered":"https:\/\/www.addictivetips.com\/?p=229665https:\/\/www.addictivetips.com\/microsoft-office\/customize-the-chart-legend-in-ms-office\/"},"modified":"2022-08-07T09:56:30","modified_gmt":"2022-08-07T06:56:30","slug":"how-to-customize-the-chart-legend-in-ms-office","status":"publish","type":"post","link":"https:\/\/tojikon.net\/en\/1939-how-to-customize-the-chart-legend-in-ms-office\/","title":{"rendered":"How To Customize The Chart Legend In MS Office"},"content":{"rendered":"

MS Word, PowerPoint, and Excel all come with a library of charts and graphs. With Excel, they\u2019re much easier to insert. You can select the data you want to plot on the axis of a graph, and Excel will take care of the rest. These charts can be copied and pasted to other MS Office files. In Excel, they\u2019re pretty intelligent; if you, for example, update the value of one of the plotted points, the chart will update automatically. The preset charts include certain elements e.g. how the title will look and where it will be placed, where the data labels will appear, where the axis titles will go, what the legend will look like, among other things. For each chart, there\u2019s a pre-decided legend however, you can change the chart legend in MS Office to any other one that you prefer.<\/p>\n

Customize Chart Legend<\/h2>\n

This works in all MS Office apps that you can create a chart\/graph in. For apps that you cannot create charts in but can paste them in e.g. Outlook, this option will not be available.<\/p>\n

Open the file with the chart you want to change the legend for, or insert a chart in a document. Make sure it\u2019s editable. Charts that you copy and paste between MS Office apps are generally editable so you won\u2019t have any trouble.<\/p>\n

Select the chart you want to change the legend for. When a chart is selected, the Chart Tools tab becomes active. Go to the Design tab on the Chart Tools tab.<\/p>\n

\"\"<\/span><\/p>\n

At the very left, you will see a button \u2018Add Chart Element\u2019. Click it and from the menu, select Legends. It will show you the different legend layouts that are supported by charts in MS Office. You can select any one of them to replace the current one. Based on the amount of space you have, you can replace the default legend with whichever one is easier to read and fits in your document.<\/p>\n

\"\"<\/span><\/p>\n

You can drag the legend to position it anywhere within the chart however, if you want to position it automatically, select the \u2018More legend Options\u2019 option from the same menu. A sidebar will open where you can customize the color and the layout of the legend.<\/p>\n

Other Chart Elements<\/h2>\n

This works for other chart elements too. They\u2019re all listed under the \u2018Add chart element\u2019 button\u2019s options and have sub-options of their own. MS Word suggests the chart elements that are best for a particular chart type but it doesn\u2019t take into account the layout of your document or if the elements are easy to read or not.<\/p>\n","protected":false},"excerpt":{"rendered":"

MS Word, PowerPoint, and Excel all come with a library of charts and graphs. With Excel, they\u2019re much easier to insert. You can select the data you want to plot on the axis of a graph, and Excel will take care of the rest. These charts can be copied and pasted to other MS Office …<\/p>\n","protected":false},"author":1,"featured_media":1940,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[23],"tags":[36],"_links":{"self":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1939"}],"collection":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/comments?post=1939"}],"version-history":[{"count":0,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1939\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media\/1940"}],"wp:attachment":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media?parent=1939"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/categories?post=1939"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/tags?post=1939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}