Where will you find options to add a border around the outside of your chart?

(adsbygoogle = window.adsbygoogle || []).push({}); Apply a predefined cell border

1. On a worksheet, select the cell or range of cells that you want to add a border to, change the border style on, or remove a border from.

2. On the Home tab, in the Font group, do one of the following:

   • To apply a new or different border style, click the arrow next to Borders

     
     , and then click a border style.

     Tip: To apply a custom border style or a diagonal border, click More Borders. In the Format Cells dialog box, on the Border tab, under Line and Color, click the line style and color that you want. Under Presets and Border, click one or more buttons to indicate the border placement. Two diagonal border buttons

     
      
     
     are available under Border.

   • To remove cell borders, click the arrow next to Borders

     
     , and then click No Border
     
     .

• The Borders button displays the most recently used border style. You can click the Borders button (not the arrow) to apply that style.

• If you apply a border to a selected cell, the border is also applied to adjacent cells that share a bordered cell boundary. For example, if you apply a box border to enclose the range B1:C5, the cells D1:D5 acquire a left border.

• If you apply two different types of borders to a shared cell boundary, the most recently applied border is displayed.

• A selected range of cells is formatted as a single block of cells. If you apply a right border to the range of cells B1:C5, the border is displayed only on the right edge of the cells C1:C5.

• If you want to print the same border on cells that are separated by a page break, but the border appears on only one page, you can apply an inside border. This way, you can print a border at the bottom of the last row of one page and use the same border at the top of the first row on the next page. Do the following:

  Transforming your company’s financial data into visuals may be old hat after you’ve added Microsoft Excel’s charts and graphs feature to your roster, but those graphics can seem to float in a sea of numbers when they’re just inserted onto a page. Adding a border to an Excel graph can help it stand out from the grid’s mass of columns and rows and call the reader’s attention. Excel allows complete customization of the borders for its graphs, whether you want to go thick and bright or simply fine-lined and minimal.

  1. 1.

     Launch Excel, open the file with the spreadsheet that has the graph and zoom in so you can see the entire graph and the white space around it on your screen.

  2. 2.

     Click the graph to enable the green Chart Tools tab. This tab only appears when the graph is actually activated. You won’t see it if you click off the graph and onto one of the grid’s surrounding cells.

  3. 3.

     Guide the cursor, without clicking, over the options in the Shape Styles section of the ribbon. These give you a sort of instant border from Excel’s default collection. They let you format the border of the graph, but you will probably want to do some customization if these options don’t exactly match your needs.

  4. 4.

     Click the Format tab, underneath the Chart Tools tab. Note that a different set of options appear on the ribbon.

  5. 5.

     Click the “Shape Outline” button. If you don’t see this button, you haven’t clicked the Format tab – you’ve only clicked the Chart Tools tab, but not the Format tab below it.

  6. 6.

     Hover over the Weight option and choose a line thickness from the fly-out menu. The higher the weight number, the thicker your border will be.

  7. 7.

     Hover over the Dashes option and choose a style for the border, such as dashed or dotted lines. You can also hover over “More Dashes” and select additional border options.

  8. 8.

     Click one of the small colored squares in the Shape Outline menu to change from the Excel gray default border to a new color. You may want to choose a color already existing in the graph or one that matches your logo, for example. If you don’t see your preferred color, click “More Outline Colors.”

  9. 9.

     Save the file by either pressing “Ctrl-S” to overwrite the borderless original or do a “Ctrl-Save As” and rename the spreadsheet to preserve the original for reference.

     Where can we find the options to add a border around the outside of your chart?

     Press ctrl+1 shortcut. Change to the Border tab in the Format Cells dialogue box and start by selecting the line style and colour. Then, either add the outside or inside borders using presets, or create the border you want by choosing individual components like the border's top, bottom, right, or left.

     What is the use of the outside border option?

     Select "Outside Borders" to select a 0.25 point line around the selected cells, or "Thick Box Border" to select a heavier stroke. You can change the "line styles" of the border. You can also select "Draw Borders" to draw borders manually with your mouse.

     How can you add a border to the data entered?

     Here's how:.

     Select a cell or a range of cells to which you want to add borders..

     On the Home tab, in the Font group, click the down arrow next to the Borders button, and you will see a list of the most popular border types..

     Click the border you want to apply, and it will be immediately added to the selected cells..