User manual

YOUR MICROSOFT OFFICE TOOLS
EXCEL MOBILE
174
8
CHAPTER
Creating a chart
1 Open the workbook you want to create
a chart from.
2 Highlight the cells you want to include
in the chart.
3 Press Menu (right action key) and
select Insert > Chart.
4 Select the type of chart, and then press
Next (right action key).
5 Confirm the area you want the chart to
include, and then press Next
(right action key).
6 Select the data layout, and then press
Next (right action key).
7 Check the boxes to indicate whether
the first row and column represent
labels.
8 Select whether you want the chart to
appear as a separate worksheet within
the current workbook, or as part of the
current worksheet.
9 Press Finish (right action key).
Formatting or changing a chart
1 Open the workbook that contains the
chart you want to format.
2 Open the chart.
3 Press Menu (right action key) and
select Format > Chart.
4 Select any of the following:
Titles: Sets the title of the chart and
headings, whether a legend appears,
and the placement of the legend.
Scale: Sets the minimum and
maximum scales for charts with an x or
y axis.
Ty p e : Sets the chart style. You can use
this setting to convert your chart to a
different format.
Series: Lets you add, modify, format, or
delete related data points without
affecting the info in your worksheet.
5 Press OK .
DID YOU KNOW ? You can also create custom
filters where you specify comparisons. Select
the filter lists, and then select Custom.
TIP To display all rows again, select the filter
lists, and then select All. To turn off filtering,
press Menu and select Tools > AutoFilter
again.