Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: You Are Unable to Create a Transparent Chart Area

XL2000: You Are Unable to Create a Transparent Chart Area

View products that this article applies to.

This article was previously published under Q212209

↑ Back to the top

Symptoms

In Microsoft Excel 2000, if you format the chart area of a chart with a fill pattern of None, the chart appears to be transparent; however, you may be unable to select the cells behind the chart.

↑ Back to the top

Cause

This behavior can occur when the following conditions are true:
  • You right-click the chart area of a chart, and then click Format Chart Area on the shortcut menu (or click Format Chart Area on the Chart toolbar).

    -and-
  • You click the Patterns tab, and then click None under Area.
Formatting the chart area with no fill pattern provides the illusion that the chart area is transparent.

↑ Back to the top

More information

This behavior differs from behavior in versions of Excel earlier than Excel 97. In versions earlier than Excel 97, if you format the chart area of an embedded chart with no fill pattern, you can access the cells behind the object by clicking them.

↑ Back to the top

Keywords: KB212209, kbprb, kbchart

↑ Back to the top

Article Info
Article ID : 212209
Revision : 5
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 232