Excel Chart Options: Adding Titles

Charts provide an easy-to-assemble but clear and persuasive illustration of your data. Excel offers a variety of charts in both two-dimensional and three-dimensional formats. Default features, however, may not provide the look and include all of the data you wish to be displayed. One common functional need of a chart is a chart title.

    1. Once you have your raw data in an Excel chart, select the Chart Area. Chart Tools contextual tabs (Design, Layout and Format) appear above the ribbon and allow you to alter your chart options. Fred Pryor Seminars_Add_Title_to_Excel_Chart_figure1
    2. Option 1: Under the Design tab, in the Chart Layouts group you can choose from several layouts that create a chart title. Once you have selected the desired default, you can alter the Chart Title textbox. Fred Pryor Seminars_Add_Title_to_Excel_Chart_figure2

  1. Option 2: If you are interested in customizing the location and alignment of your Chart Title, choose the Layout tab.
  2. In the Labels group, choose the Chart Title button to add, remove or position the chart title. Three options become available.
    • None – No chart title is displayed.
    • Centered Overlay Title – The Chart Title appears on the chart without distorting or resizing the chart you have created.
    • Above Chart – Resizes the chart you have created and displays the title at the top of the Chart Area. Fred Pryor Seminars_Add_Title_to_Excel_Chart_figure3
  3. If you are interested in more title and alignment options, choose More Title Options.
  4. The Format Chart Title dialog box appears. Select the Alignment tab. Fred Pryor Seminars_Add_Title_to_Excel_Chart_figure4
  5. Under Alignment you can change the vertical alignment, angle and text direction to better customize your chart. Play around with the chart features to get many looks.

 

Fred Pryor Seminars_Add_Title_to_Excel_Chart_figure5      Fred Pryor Seminars_Add_Title_to_Excel_Chart_figure6

 

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.


Choose a Seminar and Save $10:

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>: Beyond the Basics

Microsoft® Excel®: Beyond the Basics

Dec. 6

Central Time Zone

Dec. 8

Eastern Time Zone

Dec. 9

Pacific Time Zone

Dec. 14

Central Time Zone

Dec. 16

Eastern Time Zone

Dec. 20

Pacific Time Zone

Dec. 21

Central Time Zone

Jan. 5

Eastern Time Zone

Jan. 6

Central Time Zone

Jan. 10

Central Time Zone

Jan. 12

Eastern Time Zone

Jan. 13

Pacific Time Zone

Jan. 18

Pacific Time Zone

Jan. 19

Central Time Zone

Jan. 20

Eastern Time Zone

Jan. 24

Eastern Time Zone

Jan. 25

Central Time Zone

Jan. 26

Pacific Time Zone

Jan. 31

Central Time Zone

Feb. 2

Pacific Time Zone

Feb. 3

Eastern Time Zone

Feb. 7

Eastern Time Zone

Feb. 8

Central Time Zone

Feb. 10

Pacific Time Zone

Feb. 14

Pacific Time Zone

Feb. 15

Eastern Time Zone

Feb. 17

Central Time Zone

Feb. 22

Eastern Time Zone

Feb. 23

Pacific Time Zone

Feb. 24

Central Time Zone

Feb. 28

Central Time Zone

Mar. 2

Eastern Time Zone

Mar. 7

Pacific Time Zone

Mar. 8

Eastern Time Zone

Mar. 10

Central Time Zone

Mar. 15

Central Time Zone

Mar. 16

Pacific Time Zone

Mar. 17

Eastern Time Zone

Mar. 21

Pacific Time Zone

Mar. 23

Central Time Zone

Mar. 24

Eastern Time Zone

Mar. 28

Central Time Zone

Mar. 29

Eastern Time Zone

Mar. 31

Pacific Time Zone

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small> Basics

Microsoft® Excel® Basics

Dec. 7

Eastern Time Zone

Dec. 8

Pacific Time Zone

Dec. 13

Central Time Zone

Dec. 15

Eastern Time Zone

Dec. 19

Pacific Time Zone

Dec. 20

Central Time Zone

Jan. 4

Eastern Time Zone

Jan. 5

Central Time Zone

Jan. 9

Central Time Zone

Jan. 11

Eastern Time Zone

Jan. 12

Pacific Time Zone

Jan. 17

Pacific Time Zone

Jan. 18

Central Time Zone

Jan. 19

Eastern Time Zone

Jan. 23

Eastern Time Zone

Jan. 24

Central Time Zone

Jan. 25

Pacific Time Zone

Jan. 30

Central Time Zone

Feb. 1

Pacific Time Zone

Feb. 2

Eastern Time Zone

Feb. 6

Eastern Time Zone

Feb. 7

Central Time Zone

Feb. 9

Pacific Time Zone

Feb. 13

Pacific Time Zone

Feb. 14

Eastern Time Zone

Feb. 16

Central Time Zone

Feb. 21

Eastern Time Zone

Feb. 22

Pacific Time Zone

Feb. 23

Central Time Zone

Feb. 27

Central Time Zone

Mar. 1

Eastern Time Zone

Mar. 6

Pacific Time Zone

Mar. 7

Eastern Time Zone

Mar. 9

Central Time Zone

Mar. 14

Central Time Zone

Mar. 15

Pacific Time Zone

Mar. 16

Eastern Time Zone

Mar. 20

Pacific Time Zone

Mar. 22

Central Time Zone

Mar. 23

Eastern Time Zone

Mar. 27

Central Time Zone

Mar. 28

Eastern Time Zone

Mar. 30

Pacific Time Zone

Advanced Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>-Macros, PivotTables, Charts and More

Advanced Microsoft® Excel®-Macros, PivotTables, Charts and More

Dec. 9

Central Time Zone

Dec. 15

Eastern Time Zone

Dec. 21

Pacific Time Zone

Jan. 4

Central Time Zone

Jan. 9

Pacific Time Zone

Jan. 10

Eastern Time Zone

Jan. 17

Central Time Zone

Jan. 18

Eastern Time Zone

Jan. 26

Central Time Zone

Jan. 27

Pacific Time Zone

Jan. 30

Eastern Time Zone

Feb. 3

Central Time Zone

Feb. 7

Pacific Time Zone

Feb. 8

Eastern Time Zone

Feb. 15

Central Time Zone

Feb. 16

Eastern Time Zone

Feb. 21

Central Time Zone

Feb. 23

Pacific Time Zone

Feb. 28

Eastern Time Zone

Mar. 3

Pacific Time Zone

Mar. 7

Pacific Time Zone

Mar. 8

Central Time Zone

Mar. 13

Eastern Time Zone

Mar. 16

Central Time Zone

Mar. 22

Pacific Time Zone

Mar. 30

Central Time Zone

Mar. 31

Eastern Time Zone

Related Excel® Articles

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.

Categories

No Comments

  • Like the screen shots and the step by step procedure. Also, customization “How to do…” helps to have that option without going into the entire range of options. Thank you.