Microsoft KB Archive/73889

{|
 * width="100%"|

How to Display an Embedded Chart Using the UNHIDE Function

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for OS/2 version 3.0

-

SUMMARY
To edit an embedded chart on a worksheet, you must first unhide it. This is done manually by double-clicking the embedded (object-linked) chart, which brings up a separate chart window. To accomplish the same step using a macro, use the UNHIDE function.

MORE INFORMATION
The &quot;Function Reference&quot; states that you can use the following function to display an embedded chart window:

  UNHIDE(&quot;Sheet1 Chart2&quot;)

This is incorrect because chart objects retain names that include a space between the word &quot;chart&quot; and the number &quot;2&quot;. For example, instead of &quot;Chart2&quot; it should read &quot;Chart 2&quot;. The UNHIDE function should read as follows:

  UNHIDE(&quot;Sheet1 Chart 2&quot;)