Chart Title Border Style and Color in Excel

Home/Excel/Chart Title Border Style and Color in Excel

Changing Chart Title Border Style and Color in Excel will make your chart looks great. You change the chart title border colors and styles to match your chart layouts in Microsoft Excel 2003,2007,2010,2013.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

Chart Title Border Style and Color in Excel – Step by Step Learning

Follow the below steps to change the Chart Title Border Style and Color in Excel. In these steps, we will select chart title. We change the border styles of Excel chart title and border colors of the Excel Chart Title.

Chart Title Border Style and Color in Excel – Step 1: Select Chart Title

The first step is to select a chart title to format and change the border styles and color. The following screen-shot will show you how to activate a chart title.

Format and set background color of chart title

Chart Title Border Style and Color in Excel – Step 2: Open Format Chart Title Command

Now right click on the chart title, and you can see the quick format bar and chart title properties menu. We will format the chart title using ‘Format Chart Title’ tool.

Format and fill chart title

Chart Title Border Style and Color in Excel – Step 3: Change Border Color

Now choose the Border color form the ‘Border Color’ options of Format Chart Title Tool.

Choose border color of chart title

Now you can see the border color is changed to the color which you have set suing color tools.

Chart Title Border Style and Color in Excel – Step 3: Change Border Styles

Now go to the Border Styles commands and choose the required Border Width, Border Styles like Compound type, Border Dash Type, Border Cap Type, Border Join Type. There are many options which you can set and style your chart as you required.

Choose border style of chart title

Now you can see the chart title border styles and color is changed as per your settings. This is good way to provide borders and change the styles to match the chart themes in Excel.

By |April 20th, 2014|Excel|0 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

Leave A Comment

Related pages

formula vlookup excelexcel current worksheetexcel 2007 graph tutorialexcel vba rowsmacros basicstimevalue exceltcl commands in sqltick on excel spreadsheetexcel transfer data between worksheetsadodb connection string oracleexcel vba pivotexcel offset vbahow to use userform in excelpower vbaadvanced excel test questions and answersblank excel worksheetvba excel sort columnhow to unlock excel workbookvba choosemerging cell in excelduplicates in excel 2003vba excel trimhow to make a pivot table in excel 2010unprotect powerpointaccess 2007 vba tutorialvbscript examples for beginnersremove duplicate names in excelexcel.range vb.netexcel project management template microsoftnested if else in excelexcel merge macrosmart goals excel templatehide duplicates in excelcreate pivot table macrostacked bar chart in excel 2010meeting minute templateinstr vba functionhow to merge three columns in excelhlookup formula with exampleiferror excel 2013excel vba unprotect sheetexcel consolidate data from multiple sheetsselect vbaexcel 2007 autosave locationhow do you unlock cells in excelmacros in excel 2007 for beginnershow to work on pivot table in excel 2010definition of vlookupcell functions worksheetusing sumif excelexcel worksheet copyvba for modelershide unused cells in excelexcel vba clear contentsvba create csv filemsgbox iconvba savecopyassample excel macro codevba linefeedactivate vbacreating userforms in excelcount function in ms excelexcel formulas for analystssumif excellexcel vba workbook openexcel vba set background colorvisual basic excel commandsnested if statements excel 2013how to write an excel macroschedule excel macrodcl definition