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

excel vba check if cell is emptyexcel aptitude questionsbubble chart excel 2013excel template for timelinevba recordset fieldsvlookup excel 2003 exampleexcel lookup table tutorialremove excel sheet protectionexcel to kml macrofte calculator excelvba application.enableeventsvba array uboundopen file dialog vbavba getrowsvlookup in excel 2003 with examplebooks on excel vbalen in excelhow to use sumif functionshortcut of insert row in excelvba excel file existsvlookup and hlookup in excel with examplevba getsaveasfilenameunprotect excel worksheet without passwordcountif excel 2007how to consolidate data from multiple workbooks in excelrecordset excel vbaexcel macros vba examplesexcel vba delete rowexcel 2007 remove duplicateshow to connect excel to powerpointexcel formula remove duplicatesvlookup practiceadvanced excel shortcuts pdfundo macro excelproject gantt chart template excelpivottables in excelexcel combine worksheets into one worksheetvba change font sizevba class methodsvlookup formula in excel 2010 with examplemessage box excel vbainterview questions for beginnerscount rows excel vbaifs formula excelrange in vba excelexcel vba exampleslearn vlookup in excelunlock cells in excelproject management chart excelvba paste rangeexcel vba select workbookvlookup examples 2010how to unhide in excelexcel special characters in formulacustomer management excel templateproject timelines in excelhow to use the vlookup function in excelexcel macro merge cellshow to unlock an excel file that is password protectedvba copy row from one sheet to anotherexcel vba font colorhow to calculate difference between two dates in excelexcel filter vbavba sheet1remove duplicate vbaconcatenate in excel 2007password protect a workbookifs statement excelvba copy rangecall function in vbahow to unhide the rows in excelremove duplicate entries in excel 2010input in vbavba popup windowadvanced pivot table excel 2010 tutorialsas macro programming examples