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 formula for namesdelete duplicate cellsdefining an array in vbavba istextxlsm to xmlsave a workbook vbawhere do i find a tick in excelvbscript file existdelete all blank rows in excelexcel vba create new workbookdelete vbahow to create a userform in excel 2010vba rowsclose file vbaexcel formulas if statementshow to use average function in excel 2007shortcut key for excelsample xlsm file downloadhow to protect selected cells in excel 2007dim rs as recordsetshortcut for format cellshse meeting minutes templateddl statements in sql serverrtrim vbahow to write a query in exceluserform in excelmacros codingvba numberformatvba create tableestimation template excelvba sheet1fso filecopyfresher technical interview questions and answerspivot table in excel 2007 with example xlsexcel hide rowexcel formula and operatorexcel vba match functionmessagebox show yes novbscript examples for beginnersexcel vba programmingshared workbookexcel mysql odbcexcel 2007 paste specialhow to adjust the column width in excelexcel 2007 offsetsyntax for sql commandslookup in excel 2007how to do a vlookup for dummiesexcel chart filtervba access tutorial pdfsql interview questions for business analystvb array exampleexcel macro message boxuseful vba codesales analysis excel templatedynamic excel chartsmacros function in excelhow to convert xls to xml formatexcel functions vlookupexcel formula for finding duplicatesfso file existsappend to a text filedelete duplicate columns in excelhow to combine worksheets in excelexcel vba count rows in rangevlookup and hlookup tutorial pdfexcel macro programming tutorialexcel vba databaseexcel vba open filevlookup in microsoft exceladodb recordset methodsexcel vba sheets