Microsoft Office Tutorials and References
In Depth Information
l The Select Data Source
dialog box appears.
6
Click the Hidden and
Empty Cells button.
6
l The Hidden and Empty Cell Settings
dialog box appears.
7
Click Show Data in Hidden Rows and
Columns (
changes to
).
8
Click OK to close the Hidden and Empty
Cell Settings dialog box.
7
9
Click OK to close the Select Data Source
dialog box.
Excel displays the hidden data in your
chart.
8
Did You Know?
If you want to reposition a chart, click the chart.
A border with triple dots on all four sides of the
chart and on the corners appears. Roll your
mouse pointer over the dots. When your mouse
pointer turns into a four-headed arrow, you can
click and drag your chart.
Did You Know?
You can delete the graphical representation of a
value from a chart. For example, you can delete
the graphical representation of Region 2 in the
chart shown in this task. Just click the graphic
and then press the Delete key.
Chapter 4: Manipulate Records
99
 
Search JabSto ::




Custom Search