 Press the Picture button.
Select the folder where the image you want is located.
Select the
image.
Press the Insert button.
Move the image
to the location of your choice on the chart.
 |
You can also add
shapes to create your own pictures or framing an important part of
the chart . Combine these shapes to create the
composition you want. You will find
under the Format tab group Arrange commands that allow you to change
the order forms and group them. |
You can also add text boxes, which adds short
explanations to the chart.
Press the Text
Box.
Place the cursor where you
want.
Enter the
text of your choice.
You can then
change the shape of the text box and move it to the desired location on
the chart .
 |
A chart should have a title
that represents the content or idea to be transmitted (higher sales
...) Excel offers three choices outlined by the image at
left. You can always adjust the location of the track,
keeping a finger on the left mouse button and move it. |
 |
An Excel
chart can have up to three axes. The options outlined in the image on the
left show the potential along the axis chosen. |
 |
A chart legend shows the names of each data
series. The options here allow you to decide where you
want to have it in the chart. The list provided is
where we find the legend most. You can
always select the chart with the mouse and move it to a specific
location.
|
 |
The data labels show the value next to the
data point on the chart . You can view the label to all points on the
chart for a data set or even a particular point. Once posted, you can change its location
and presentation (size, color ...) |
 |
The display of the axes used to display
descriptions of data sets and the values they represent.
Seen
on the right image the years on the horizontal axis (X), the
description of the series on the depth axis and values on the
vertical axis (also called the y-axis or Y). |
 |
Gridlines are very
important. The vertical gridline is used to
group the valuesin the same period. The horizontal gridline allows to compare data from different periods. |
 |
The plot area is the bottom of the chart for 2D charts.
You can change the presentation, such as a gradient
background image on the right, or place an image representative if
you wish. |
 |
 |
The wall is the term used to describe the
background of a chart in three dimensions. As for the plot
area, you can insert color, gradient colors, an image or
pattern. |
 |
 |
The chart's floor is the term
used to describe the bottom of a 3D chart.
As for the plot area and the
wall chart, you can "decorate" in different ways. |
 |
 |
The 3D rotation can change the chart orientation on
the three axes. You can change the 3D view to get a better overview of the data. |
 |
Here is
the same chart with a different orientation. |
 
It is sometimes difficult to determine a trend from a mass
of data. That is why a trendline can give you a better highlight the
results. The chart above shows the linear trendlines
(green), the exponential curve (red) and the trend of linear prediction
(blue).
 
The lines can best
represent the data. There are the projection lines to show up and
lines up/down to see the range between the minimum and maximum for each
period. The chart at right
shows what type of line. C This type of line is only
available for stock charts.
 
The Up/Down bars are another representation of lines
seen just before. They also show the minimum and maximum for
each period.
 
Error bars indicate the margins of error based on certain criteria.
This tab allows you to really change the
presentation of each of the components of the chart . It is here that improvements to the presentation of your
chart will be realized. With Excel 2010 only, you can
double-click on an item for a full list of options for presenting an
item. You can also select
the desired item and press the right mouse button and choose Format
...
Like the Layout tab, the first option
lets you select the item you want from the list or items available on the chart. This is useful when there are multiple elements grouped
near one another.
 |
This option
opens the window with a list of all possible layout options for the
selected item. Double click on the item or the right mouse button and
Formatting will take you to the same menu. |
You can experiment as much as you like
knowing you can always revert to basic options. This is the rationale for this
option. Experiment to find the best format for your
chart.
 |
You can choose from predefined presentation
styles. The gallery lets
you choose from multiple colors and gradients.
There are more options in the Fill section of forms. |
This option allows you to determine the
merits of the chart or elements of the data sets, color, pattern, gradient
or image of your choice.
Select one data series.
Press the right mouse button.
Select a Format Data
Series.
Select Fill.
There
are already options for colors, gradients and textures. You can customize these
options further.
Select
the desired item.
From the Layout tab or Formatting, select the Formatting option
selection.
Select Fill.
The transparency option allows you to remove the emphasis on some
data or so
you can see the data that are masked by others.
The a data serie with gradient fill "pops" to the eye compared to the rest. There are preset colors or you can
create your own gradient fill with many colors. Use the buttons  to add or remove color bars for the color transition.
Move the  bars to determine where the colors will change on the bar and use the  bouton to determine the color of your choice.
You can also
insert pictures to represent data. This
can be a library of clip art image of Microsoft Office or other image that
meets the needs.
Select a
data series.
Select Format Series.
From the Fill menu, select Fill.
Select Picture or texture
fill.
For the example above, select Clip Art.
Do a search on the item of your choice and select an image.
Press OK.
The selected image will be "stretched"
along the entire length of the bar.
This may satisfy your needs. But the "stack" option is
also very interesting. It allows, as the name says, stacking the images one over
the other to represent the data series.
In the above case, a complete image is displayed for each value of
5. There are three images to represent 15, 4 planes to
represent 20 and 5 for 25 aircraft. It may be necessary to hide the outline of the
shape.
 |
You can emphasize the shapes of data
sets by changing the shape outline. You can change the color to contrast with the
background color. You can also
change the line thickness to stand out or put dashes.
But it would have a negative impact on the effects on the
shapes. |
 |
The effect of placing a shadow or a shape of a
surround effect of light color are interesting. However, that
made the charts in Excel 2007 also popular is the fact that Bevel up a
great relief on the data bars. The chart at right shows the effects of several forms with different bevels for each
bar. Find the one that
best represent your data. |
 |
The 3-D rotation effect applies to some
elements such as an entire chart or shapes.
 |
You can use the WordArt style to any text
included in the chart.
Select the text of your choice.
Press the button at the end
of the WordArt window to view her gallery.
Select from the options available. |
 |
Among the elements that can
compose, you can include forms to compose your own images.
Arrange the grouping
options you can change the display order and the alignment of
forms. |
Size
 |
Determine the size of the
chart if it is on a worksheet. The chart takes the whole screen
if placed on a chart sheet. |
|
