create a chart from start to finish

8/20/2019 Create a Chart From Start to Finish

1/27

Create a chart from start to nish

Microsoft Excel no longer provides the chart wizard. Instead, you can create a

basic chart by clicking the chart type that you want on the Insert tab in

the Charts group. To create a chart that displays the details that you want,you can then continue with the next steps of the following step-by-step

process.

earn about charts

!etting to know the ele"ents of a chart

Modifying a basic chart to "eet your needs

#pplying a prede$ned chart layout and chart style for a professional look

#dding eye-catching for"atting to a chart

%eusing charts by creating chart te"plates

&tep '( )reate a basic chart

&tep *( )hange the layout or style of a chart

#pply a prede$ned chart layout

#pply a prede$ned chart style

)hange the layout of chart ele"ents "anually

)hange the for"at of chart ele"ents "anually

&tep +( #dd or re"ove titles or data labels

#dd a chart title

#dd axis titles

ink a title to a worksheet cell

#dd data labels

https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902069https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902070https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902071https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902072https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902073https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902074https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902075https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902076https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902077https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902078https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902079https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902080https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902081https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902082https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902083https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902084https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902085https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902070https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902071https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902072https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902073https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902074https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902075https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902076https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902077https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902078https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902079https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902080https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902081https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902082https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902083https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902084https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902085https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902069


2/27

%e"ove titles or data labels fro" a chart

&tep ( &how or hide a legend

&tep ( isplay or hide chart axes or gridlines

isplay or hide pri"ary axes

isplay or hide secondary axes

isplay or hide gridlines

&tep /( Move or resize a chart

Move a chart

%esize a chart

&tep 0( &ave a chart as a te"plate

Learn about charts

)harts are used to display series of nu"eric data in a graphical for"at to

"ake it easier to understand large 1uantities of data and the relationship

between di2erent series of data.

To create a chart in Excel, you start by entering the nu"eric data for the

chart on a worksheet. Then you can plot that data into a chart by selecting

the chart type that you want to use on the Insert tab, in the Charts group.

https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902086https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902087https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902088https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902089https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902090https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902091https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902092https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902093https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902094https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902095https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902086https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902087https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902088https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902089https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902090https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902091https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902092https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902093https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902094https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#__toc255902095


3/27

'. 3orksheet data

*. )hart created fro" worksheet data

Excel supports "any types of charts to help you display data in ways that

are "eaningful to your audience. 3hen you create a chart or change an

existing chart, you can select fro" a variety of chart types 4such as a colu"n

chart or a pie chart5 and their subtypes 4such as a stacked colu"n chart or a

pie in +- chart5. 6ou can also create a co"bination chart by using "ore than

one chart type in your chart.

Exa"ple of a co"bination chart that uses a colu"n and line chart type.


4/27

7or "ore infor"ation about the chart types that you can select in Excel,

see #vailable chart types.

Getting to know the elements of a chart

# chart has "any ele"ents. &o"e of these ele"ents are displayed by

default, others can be added as needed. 6ou can change the display of the

chart ele"ents by "oving the" to other locations in the chart, resizing

the", or by changing the for"at. 6ou can also re"ove chart ele"ents that

you do not want to display.

'. The chart area of the chart.

*. The plot area of the chart.

+. The data points of the data series that are plotted in the chart.

. The horizontal 4category5 and vertical 4value5 axis along which the data is

plotted in the chart.

. The legend of the chart.

/. # chart and axis title that you can use in the chart.

http://office.microsoft.com/redir/HA010342187http://office.microsoft.com/redir/HA010342187


5/27

0. # data label that you can use to identify the details of a data point in a

data series.

Top of 8age

Modifying a basic chart to meet your needs

#fter you create a chart, you can "odify any one of its ele"ents. 7or

exa"ple, you "ight want to change the way that axes are displayed, add a

chart title, "ove or hide the legend, or display additional chart ele"ents.

To "odify a chart, you can do one or "ore of the following(

•

Change the display of chart axes 6ou can specify the scale of axes and ad9ust the interval between the values or categories that are

displayed. To "ake your chart easier to read, you can also add tick "arks to

an axis, and specify the interval at which they will appear.

• Add titles and data labels to a chart To help clarify the

infor"ation that appears in your chart, you can add a chart title, axis titles,

and data labels.

• Add a legend or data table 6ou can show or hide a legend,

change its location, or "odify the legend entries. In so"e charts, you can

also show a data table that displays the legend keys and the values that are

presented in the chart.

• Apply special options for each chart type &pecial lines 4such as

high-low lines and trendlines5, bars 4such as up-down bars and error bars5,

data "arkers, and other options are available for di2erent chart types.

Top of 8age

#pplying a prede$ned chart layout and chart style for a professional look

Instead of "anually adding or changing chart ele"ents or for"atting the

chart, you can 1uickly apply a prede$ned chart layout and chart style to your

chart. Excel provides a variety of useful prede$ned layouts and styles.

:owever, you can $ne-tune a layout or style as needed by "aking "anual

changes to the layout and for"at of individual chart ele"ents, such as the

chart area, plot area, data series, or legend of the chart.

https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#tophttps://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#tophttps://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#tophttps://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#top


6/27

3hen you apply a prede$ned chart layout, a speci$c set of chart ele"ents

4such as titles, a legend, a data table, or data labels5 are displayed in a

speci$c arrange"ent in your chart. 6ou can select fro" a variety of layouts

that are provided for each chart type.

3hen you apply a prede$ned chart style, the chart is for"atted based on thedocu"ent the"e that you have applied, so that your chart "atches your

organization;s or your own the"e colors 4a set of colors5, the"e fonts 4a set

of heading and body text fonts5, and the"e e2ects 4a set of lines and $ll

e2ects5.

6ou cannot create your own chart layouts or styles, but you can create chart

te"plates that include the chart layout and for"atting that you want.

Top of 8age

#dding eye-catching for"atting to a chart

In addition to applying a prede$ned chart style, you can easily apply

for"atting to individual chart ele"ents such as data "arkers, the chart area,

the plot area, and the nu"bers and text in titles and labels to give your chart

a custo", eye-catching look. 6ou can apply speci$c shape styles and 3ord#rt

styles, and you can also for"at the shapes and text of chart ele"ents

"anually.

To add for"atting, you can use one or "ore of the following(

• Fill chart elements 6ou can use colors, textures, pictures, and

gradient $lls to help draw attention to speci$c chart ele"ents.

• Change the outline of chart elements 6ou can use colors, line

styles, and line weights to e"phasize chart ele"ents.

• Add special eects to chart elements 6ou can apply special

e2ects, such as shadow, re


7/27

%eusing charts by creating chart te"plates

If you want to reuse a chart that you custo"ized to "eet your needs, you

can save that chart as a chart te"plate 4=.crtx5 in the chart te"plates folder.

3hen you create a chart, you can then apply the chart te"plate 9ust as you

would any other built-in chart type. In fact, chart te"plates are custo" charttypes > you can also use the" to change the chart type of an existing chart.

If you use a speci$c chart te"plate fre1uently, you can save it as the default

chart type.

Top of 8age

&tep '( )reate a basic chart

7or "ost charts, such as colu"n and bar charts, you can plot the data that

you arrange in rows or colu"ns on a worksheet into a chart. :owever, so"echart types 4such as pie and bubble charts5 re1uire a speci$c data

arrange"ent.

'. ?n the worksheet, arrange the data that you want to plot in a chart.

The data can be arranged in rows or colu"ns > Excel auto"atically

deter"ines the best way to plot the data in the chart. &o"e chart types

4such as pie and bubble charts5 re1uire a speci$c data arrange"ent.

!ow to arrange data on the worksheet

For this

chart

type

Arrange the data

)olu"n,

bar, line,

area,

surface,

or radar

chart

In colu"ns or rows, such as(

ore" Ipsu"

' *

+

?r(

ore" ' +

Ipsu" *

https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#tophttps://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#top


8/27

For this

chart

type

Arrange the data

8ie or

doughnutchart

7or one data series, in one colu"n or row of

data and one colu"n or row of data labels,such as(

# '

@ *

) +

?r(

# @ )

' * +

7or "ultiple data series, in "ultiple colu"ns

or rows of data and one colu"n or row of

data labels, such as(

# ' *

@ +

) /

?r(

# @ )

' * +

/

A6

4scatter5

or bubble

chart

In colu"ns, placing x values in the $rst

colu"n and corresponding y values and

bubble size values in ad9acent colu"ns, such

as(

A 6 @ubble size

' * +

/


9/27

For this

chart

type

Arrange the data

&T?)B

):#%T

In colu"ns or rows in the following order,

using na"es or dates as labels(

high values, low values, and closing values

ike(

ate :igh ow )lose

'C'C*DD* /.'* * .D/+

?r(

ate 'C'C*DD*

:igh /.'*

ow *

)lose .D/+

*. &elect the cells that contain the data that you want to use for the

chart.

"ip If you select only one cell, Excel auto"atically plots all cells that

contain data that is ad9acent to that cell into a chart. If the cells that youwant to plot in a chart are not in a continuous range, you can select

nonad9acent cells or ranges as long as the selection for"s a rectangle. 6ou

can also hide the rows or colu"ns that you do not want to plot in the chart.

!ow to select cells# ranges# rows# or columns

"o select $o this

# single cell )lick the cell, or press the arrow keys

to "ove to the cell.

# range of cells )lick the $rst cell in the range, and

then drag to the last cell, or hold down

&:I7T while you press the arrow keys

to extend the selection.

6ou can also select the $rst cell in the

range, and then press 7 to extend

https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#8950714https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#8950714https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#8950714https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#8950714https://support.office.com/en-in/article/Create-a-chart-from-start-to-finish-a745775f-98d9-4c63-bfa8-9c00cd03ff0c#8950714


10/27

"o select $o this

the selection by using the arrow keys.

To stop extending the selection, press

7 again.

# large range of cells

)lick the $rst cell in the range, andthen hold down &:I7T while you click

the last cell in the range. 6ou can

scroll to "ake the last cell visible.

#ll cells on a

worksheet

)lick the %elect All button.

To select the entire worksheet, you

can also press )T%F#.

G?TE If the worksheet contains data,

)T%F# selects the current region.

8ressing )T%F# a second ti"e

selects the entire worksheet.

Gonad9acent

cells or cell

ranges

&elect the $rst cell or range of cells,

and then hold down )T% while you

select the other cells or ranges.

6ou can also select the $rst cell or

range of cells, and then press

&:I7TF7 to add another nonad9acent

cell or range to the selection. To stop

adding cells or ranges to the selection,

press &:I7TF7 again.

G?TE 6ou cannot cancel the selection

of a cell or range of cells in anonad9acent selection without

canceling the entire selection.

#n entire row or

colu"n

)lick the row or colu"n heading.


11/27

"o select $o this

'. %ow heading

*. )olu"n heading

6ou can also select cells in a row or

colu"n by selecting the $rst cell and

then pressing )T%F&:I7TF#%%?3

key 4%I!:T #%%?3 or E7T #%%?3

for rows, H8 #%%?3 or ?3G #%%?3for colu"ns5.

G?TE If the row or colu"n contains

data, )T%F&:I7TF#%%?3 key

selects the row or colu"n to the last

used cell. 8ressing

)T%F&:I7TF#%%?3 key a second

ti"e selects the entire row or colu"n.

#d9acent rows

or colu"ns

rag across the row or colu"n

headings. ?r select the $rst row or

colu"n then hold down &:I7T while

you select the last row or colu"n.

Gonad9acent

rows or

colu"ns

)lick the colu"n or row heading of the

$rst row or colu"n in your selection

then hold down )T% while you click

the colu"n or row headings of other

rows or colu"ns that you want to add

to the selection.

The $rst or lastcell in a row or

colu"n

&elect a cell in the row or colu"n, andthen press )T%F#%%?3 key 4%I!:T

#%%?3 or E7T #%%?3 for rows, H8

#%%?3 or ?3G #%%?3 for

colu"ns5.

The $rst or last

cell on a

8ress )T%F:?ME to select the $rst

cell on the worksheet or in an Excel


12/27

"o select $o this

worksheet or in

a Microsoft

?Jce Excel

table

list.

8ress )T%FEG to select the last cell

on the worksheet or in an Excel list

that contains data or for"atting.

)ells to the last

used cell on the

worksheet

4lower-right

corner5

&elect the $rst cell, and then press

)T%F&:I7TFEG to extend the

selection of cells to the last used cell

on the worksheet 4lower-right corner5.

)ells to the

beginning of

the worksheet

&elect the $rst cell, and then press

)T%F&:I7TF:?ME to extend the

selection of cells to the beginning of

the worksheet.More or fewer

cells than the

active selection

:old down &:I7T while you click the

last cell that you want to include in the

new selection. The rectangular range

between the active cell and the cell

that you click beco"es the new

selection.

TI8 To cancel a selection of cells, click any cell on the worksheet.

+. ?n the Insert tab, in the Charts group, do one of the following(o )lick the chart type, and then click a chart subtype that you want

to use.

o To see all available chart types, click to launch the Insert

Chart dialog box, and then click the arrows to scroll through the chart types.

"ip # &creenTip displays the chart type na"e when you rest the "ouse

pointer over any chart type or chart subtype. 7or "ore infor"ation about the

chart types that you can use, see #vailable chart types.

http://office.microsoft.com/redir/HA010342187http://office.microsoft.com/redir/HA010342187


13/27

. @y default, the chart is placed on the worksheet as an e"bedded

chart. If you want to place the chart in a separate chart sheet, you can

change its location by doing the following(

a. )lick anywhere in the e"bedded chart to activate it.

This displays the Chart "ools, adding the $esign, Layout,

and Format tabs.

b. ?n the $esign tab, in the Location group, click Mo&e Chart.

c. Hnder Choose where you want the chart to be placed , do one of

the following(

To display the chart in a chart sheet, click 'ew sheet.

"ip If you want to replace the suggested na"e for the chart, you can type

a new na"e in the 'ew sheet box.

To display the chart as an e"bedded chart in a worksheet,

click (b)ect in, and then click a worksheet in the (b)ect in box.

*. Excel auto"atically assigns a na"e to the chart, such as Chart* if it isthe $rst chart that you create on a worksheet. To change the na"e of the

chart, do the following(

a. )lick the chart.

b. ?n the Layout tab, in the +roperties group, click the Chart

'ame text box.

"ip If necessary, click the +roperties icon in the +roperties group to

expand the group.

c. Type a new na"e.

d. 8ress EGTE%.

'otes

• To 1uickly create a chart that is based on the default chart type, select

the data that you want to use for the chart, and then press #TF7' or 7''.


14/27

3hen you press #TF7', the chart is displayed as an e"bedded chart when

you press 7'', the chart is displayed on a separate chart sheet.

• If you no longer need a chart, you can delete it. )lick the chart to

select it, and then press EETE.

Top of 8age

&tep *( )hange the layout or style of a chart

#fter you create a chart, you can instantly change its look. Instead of

"anually adding or changing chart ele"ents or for"atting the chart, you can

1uickly apply a prede$ned layout and style to your chart. Excel provides a

variety of useful prede$ned layouts and styles 4or 1uick layouts and 1uick

styles5 that you can select fro", but you can custo"ize a layout or style as

needed by "anually changing the layout and for"at of individual chart

ele"ents.

#pply a prede$ned chart layout

'. )lick anywhere in the chart that you want to for"at by using a

prede$ned chart layout.


and Format tabs.

*. ?n the $esign tab, in the Chart Layouts group, click the chart layout

that you want to use.

'ote 3hen the size of the Excel window is reduced, chart layouts will be

available in the ,uick Layoutgallery in the Chart Layouts group.

"ip To see all available layouts, click More .

Top of 8age

#pply a prede$ned chart style

'. )lick anywhere in the chart that you want to for"at by using a

prede$ned chart style.



15/27


and Format tabs.

*. ?n the $esign tab, in the Chart %tyles group, click the chart style

that you want to use.

'ote 3hen the size of the Excel window is reduced, chart styles will be

available in the Chart ,uick %tylesgallery in the Chart %tyles group.

"ip To see all prede$ned chart styles, click More .

Top of 8age

)hange the layout of chart ele"ents "anually

'. )lick the chart ele"ent for which you want to change the layout, or do

the following to select it fro" a list of chart ele"ents.

a. )lick anywhere in the chart to display the Chart "ools.

b. ?n the Format tab, in the Current %election group, click the

arrow in the Chart -lements box, and then click the chart ele"ent that you

want.

*. ?n the Layout tab, in the Labels, Axes, or .ackground group, click

the chart ele"ent button that corresponds with the chart ele"ent that you

selected, and then click the layout option that you want.



16/27

'ote The layout options that you select are applied to the chart ele"entthat you have selected. 7or exa"ple, if you have the entire chart selected,

data labels will be applied to all data series. If you have a single data point

selected, data labels will only be applied to the selected data series or data

point.

Top of 8age

)hange the for"at of chart ele"ents "anually

'. )lick the chart ele"ent for which you want to change the style, or do

the following to select it fro" a list of chart ele"ents.a. )lick anywhere in the chart to display the Chart "ools.


arrow in the Chart -lements box, and then click the chart ele"ent that you

want.

*. ?n the Format tab, do one or "ore of the following(

a. To for"at any selected chart ele"ent, in the Current

%election group, click Format %election, and then select the for"atting

options that you want.

b. To for"at the shape of a selected chart ele"ent, in the %hape

%tyles group, click the style that you want, or click %hape Fill, %hape

(utline, or %hape -ects, and then select the for"atting options that you

want.

c. To for"at the text in a selected chart ele"ent by using 3ord#rt,in the /ordArt %tyles group, click a style. 6ou can also click "ext Fill, "ext

(utline, or "ext -ects, and then select the for"atting options that you

want.

'ote #fter you apply a 3ord#rt style, you cannot re"ove the 3ord#rt

for"at. If you do not want the 3ord#rt style that you applied, you can select



17/27

another 3ord#rt style, or you can click 0ndo on the ,uick Access

"oolbar to return to the previous text for"at.

"ip To use regular text for"atting to for"at the text in chart ele"ents, you

can right-click or select the text, and then click the for"atting options that

you want on the Mini toolbar. 6ou can also use the for"atting buttons onthe ribbon 4!ome tab, Font group5.

Top of 8age

&tep +( #dd or re"ove titles or data labels

To "ake a chart easier to understand, you can add titles, such as a chart title

and axis titles. #xis titles are typically available for all axes that can be

displayed in a chart, including depth 4series5 axes in +- charts. &o"e chart

types 4such as radar charts5 have axes, but they cannot display axis titles.)hart types that do not have axes 4such as pie and doughnut charts5 cannot

display axis titles either.

6ou can also link chart and axis titles to corresponding text in worksheet cells

by creating a reference to those cells. inked titles are auto"atically updated

in the chart when you change the corresponding text on the worksheet.

To 1uickly identify a data series in a chart, you can add data labels to the

data points of the chart. @y default, the data labels are linked to values on

the worksheet, and they update auto"atically when changes are "ade tothese values.

#dd a chart title

'. )lick anywhere in the chart to which you want to add a title.


and Format tabs.

*. ?n the Layout tab, in the Labels group, click Chart "itle.

+. )lick Centered (&erlay "itle or Abo&e Chart.



18/27

. In the Chart "itle text box that appears in the chart, type the text that

you want.

"ip To insert a line break, click to place the pointer where you want to

break the line, and then press EGTE%.

. To for"at the text, select it, and then click the for"atting options that

you want on the Mini toolbar.

"ip 6ou can also use the for"atting buttons on the ribbon

4!ome tab, Font group5. To for"at the whole title, you can right-click it,

click Format Chart "itle, and then select the for"atting options that you

want.

Top of 8age

#dd axis titles

'. )lick anywhere in the chart to which you want to add axis titles.


and Format tabs.

*. ?n the Layout tab, in the Labels group, click Axis "itles.

+. o one or "ore of the following(

o To add a title to a pri"ary horizontal 4category5 axis,

click +rimary !ori1ontal Axis "itle, and then click the option that you

want.

"ip If the chart has a secondary horizontal axis, you can also

click %econdary !ori1ontal Axis "itle.

o To add a title to pri"ary vertical 4value5 axis, click +rimary

2ertical Axis "itle, and then click the option that you want.

"ip If the chart has a secondary vertical axis, you can also

click %econdary 2ertical Axis "itle.



19/27

o To add a title to a depth 4series5 axis, click $epth Axis "itle,

and then click the option that you want.

'ote This option is only available when the selected chart is a true +-

chart, such as a +- colu"n chart.

. In the Axis "itle text box that appears in the chart, type the text that

you want.

"ip To insert a line break, click to place the pointer where you want to

break the line, and then press EGTE%.

. To for"at the text, select it, and then click the for"atting options that

you want on the Mini toolbar.

"ip 6ou can also use the for"atting buttons on the ribbon4!ome tab, Font group5. To for"at the whole title, you can right-click it,

click Format Axis "itle , and then select the for"atting options that you

want.

'otes

• If you switch to another chart type that does not support axis titles

4such as a pie chart5, the axis titles will no longer be displayed. The titles will

be displayed again when you switch back to a chart type that does support

axis titles.• #xis titles that are displayed for secondary axes will be lost when you

switch to a chart type that does not display secondary axes.

Top of 8age

ink a title to a worksheet cell

'. ?n a chart, click the chart or axis title that you want to link to a

worksheet cell.

*. ?n the worksheet, click in the for"ula bar, and then type an e1ual sign

4K5.

+. &elect the worksheet cell that contains the data or text that you want

to display in your chart.



20/27

"ip 6ou can also type the reference to the worksheet cell in the for"ula

bar. Include an e1ual sign, the sheet na"e, followed by an excla"ation point

for exa"ple, 3%heet*4F5

. 8ress EGTE%.

Top of 8age

#dd data labels

'. ?n a chart, do one of the following(

o To add a data label to all data points of all data series, click the

chart area.

o To add a data label to all data points of a data series, click

anywhere in the data series that you want to label.

o To add a data label to a single data point in a data series, click

the data series that contains the data point that you want to label, and then

click the data point that you want to label.


and Format tabs.

*. ?n the Layout tab, in the Labels group, click $ata Labels, and then

click the display option that you want.

'ote epending on the chart type that you used, di2erent data label

options will be available.

Top of 8age

%e"ove titles or data labels fro" a chart

'. )lick the chart.


and Format tabs.

*. ?n the Layout tab, in the Labels group, do one of the following(



21/27

o To re"ove a chart title, click Chart "itle, and then click 'one.

o To re"ove an axis title, click Axis "itle, click the type of axis

title that you want to re"ove, and then click'one.

o To re"ove data labels, click $ata Labels, and then click 'one.

"ip To 1uickly re"ove a title or data label, click it, and then press EETE.

Top of 8age

&tep ( &how or hide a legend

3hen you create a chart, the legend appears, but you can hide the legend or

change its location after you create the chart.

'. )lick the chart in which you want to show or hide a legend.


and Format tabs.

*. ?n the Layout tab, in the Labels group, click Legend.

+. o one of the following(

o To hide the legend, click 'one.

"ip To 1uickly re"ove a legend or a legend entry fro" a chart, you can

select it, and then press EETE. 6ou can also right-click the legend or alegend entry, and then click $elete.

o To display a legend, click the display option that you want.

'ote 3hen you click one of the display options, the legend "oves, and the

plot area auto"atically ad9usts to "ake roo" for it. If you "ove and size the

legend by using the "ouse, the plot area does not auto"atically ad9ust.



22/27

o 7or additional options, click More Legend (ptions, and then

select the display option that you want.

"ip @y default, a legend does not overlap the chart. If you have space

constraints, you "ight be able to reduce the size of the chart by clearing

the %how the legend without o&erlapping the chart check box.

"ip 3hen a chart has a legend displayed, you can "odify the individual

legend entries by editing the corresponding data on the worksheet. 7or

additional editing options, or to "odify legend entries without a2ecting the

worksheet data, you can change the legend entries in the %elect $ata

%ource dialog box 4$esign tab, $atagroup, %elect $ata button5.

Top of 8age

&tep ( isplay or hide chart axes or gridlines

3hen you create a chart, pri"ary axes are displayed for "ost chart types.

6ou can turn the" on or o2 as needed. 3hen you add axes, you can specify

the level of detail that you want the axes to display. # depth axis is displayed

when you create a +- chart.

3hen the values in a chart vary widely fro" data series to data series, or

when you have "ixed types of data 4for exa"ple, price and volu"e5, you can

plot one or "ore data series on a secondary vertical 4value5 axis. The scale

of the secondary vertical axis re


23/27

o To display an axis, click +rimary !ori1ontal Axis, +rimary

2ertical Axis, or $epth #xis 4on a +- chart5, and then click the axis display

option that you want.

o To hide an axis, click +rimary !ori1ontal Axis, +rimary

2ertical Axis, or $epth #xis 4on a +- chart5, and then click 'one.

o To specify detailed axis display and scaling options,

click +rimary !ori1ontal Axis, +rimary 2ertical Axis, or $epth Axis 4on

a +- chart5, and then click More +rimary !ori1ontal Axis (ptions, More

+rimary 2ertical Axis (ptions, or More $epth Axis (ptions.

Top of 8age

isplay or hide secondary axes

'. In a chart, click the data series that you want to plot along a secondary

vertical axis, or do the following to select the data series fro" a list of chart

ele"ents(

a. )lick the chart.


and Format tabs.


arrow in the Chart -lements box, and then click the data series that you

want to plot along a secondary vertical axis.

*. ?n the Format tab, in the Current %election group, click Format

%election.

+. )lick %eries (ptions if it is not selected, and then under +lot %eries

(n, click %econdary Axis and then clickClose.

. ?n the Layout tab, in the Axes group, click Axes.



24/27

. o one of the following(

o To display a secondary vertical axis, click %econdary 2ertical

Axis, and then click the display option that you want.

"ip To help distinguish the secondary vertical axis, you can change the

chart type for 9ust one data series. 7or exa"ple, you can change one data

series to a line chart.

2. To display a secondary horizontal axis, click %econdary !ori1ontal

Axis, and then click the display option that you want.

'ote This option is available only after you display a secondary vertical

axis.

3. To hide a secondary axis, click %econdary 2ertical

Axis or %econdary !ori1ontal Axis, and then click 'one.

"ip 6ou can also click the secondary axis that you want to delete, and then

press EETE.

Top of 8age

isplay or hide gridlines

'. )lick the chart for which you want to display or hide chart gridlines.


and Format tabs.

*. ?n the Layout tab, in the Axes group, click Gridlines.

+. o the following(



25/27

o To add horizontal gridlines to the chart, point to +rimary

!ori1ontal Gridlines, and then click the option that you want. If the chart

has a secondary horizontal axis, you can also click %econdary !ori1ontal

Gridlines.

o To add vertical gridlines to the chart, point to +rimary 2erticalGridlines, and then click the option that you want. If the chart has a

secondary vertical axis, you can also click %econdary 2ertical Gridlines.

o To add depth gridlines to a +- chart, point to $epth Gridlines,

and then click the option that you want. This option is only available when

the selected chart is a true +- chart, such as a +- colu"n chart.

o To hide chart gridlines, point to +rimary !ori1ontal

Gridlines, +rimary 2ertical Gridlines, or $epth Gridlines 4on a +-

chart5, and then click 'one. If the chart has a secondary axes, you can also

click%econdary !ori1ontal Gridlines or %econdary 2ertical Gridlines,and then click 'one.

o To 1uickly re"ove chart gridlines, select the", and then press

EETE.

Top of 8age

&tep /( Move or resize a chart

6ou can "ove a chart to any location on a worksheet or to a new or existing

worksheet. 6ou can also change the size of the chart for a better $t.

Move a chart

• To "ove a chart, drag it to the location that you want.

Top of 8age

%esize a chart

To resize a chart, do one of the following(

• )lick the chart, and then drag the sizing handles to the size that you

want.

• ?n the Format tab, in the %i1e group, enter the size in the %hape

!eight and %hape /idth box.



26/27

"ip 7or "ore sizing options, on the Format tab, in the %i1e group, clickto launch the Format Chart Areadialog box. ?n the %i1e tab, you can

select options to size, rotate, or scale the chart. ?n the +roperties tab, you

can specify how you want the chart to "ove or size with the cells on the

worksheet.

Top of 8age

&tep 0( &ave a chart as a te"plate

If you want to create another chart such as the one that you 9ust created,you can save the chart as a te"plate that you can use as the basis for other

si"ilar charts

'. )lick the chart that you want to save as a te"plate.

*. ?n the $esign tab, in the "ype group, click %a&e as "emplate.

+. In the File name box, type a na"e for the te"plate.

"ip Hnless you specify a di2erent folder, the te"plate $le 4.crtx5 will be

saved in the Charts folder, and the te"plate beco"es available

under "emplates in both the Insert Chart dialog box

4Insert tab, Charts group,$ialog .ox Launcher 5 and the Change

Chart "ype dialog box 4$esign tab, "ype group, Change Chart "ype5.

'ote # chart te"plate contains chart for"atting and stores the colors that

are in use when you save the chart as a te"plate. 3hen you use a chart

te"plate to create a chart in another workbook, the new chart uses the

colors of the chart te"plate > not the colors of the docu"ent the"e that is

currently applied to the workbook. To use the docu"ent the"e colors instead

of the chart te"plate colors, right-click the chart area, and then click 6eset

to Match %tyle.



27/27

Top of 8age

Applies "o7 Excel *DD0, Excel *D'D, Excel &tarter

create a chart from start to finish

Documents