How to Display an Embedded Chart Using the UNHIDE Function

ID: Q73889

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 "Function Reference" states that you can use the following function to display an embedded chart window:


   UNHIDE("Sheet1 Chart2")

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


   UNHIDE("Sheet1 Chart 2")

REFERENCES

"Function Reference," version 4.0, page 441

"Microsoft Excel Function Reference," version 3.0, page 241

Additional query words: docerr

Keywords :
Version :
Platform :
Issue type :