how to add a bottom border in excel for mac

Add A Bottom Border In Excel Series Name To

By default, it may show in the bottom or right side of the chart.

Consider a small table which represents the sales of A and B for the year 2011, 2012 and 2013.

If we observe, A and B are representing two different colors and the bars are also representing the same color for 2011,2012 and 2013.

If we place the cursor on the legend keys it will pop up the message.

Click on the symbol on the top right-hand side of the chart.

If we want to keep the legend on the Top select Top similarly as Right, Left, and Bottom.

If we want to overlap the legend on the chart then click on the More options available on the Legend.

Add A Bottom Border In Excel Series Name To

As we want to change the series name to XYZ, change the name to XYZ and then click on OK.

Under the border option select the Solid Line then it will create a border for the Legend.

Instead of color, we can also select Gradient fill, Pattern fill, and picture.

Here we discuss how to add, remove and change the position of legends in an Excel chart along with practical examples and downloadable excel template.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

How To Add A Bottom Border In Excel For Mac