View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Excel bounding boxes on chart data sources

Hi John,

By "bounding boxes" I assume that you mean the highlight around the source
data.

One reason might be what you are selecting - for example, if you select the
chart gridlines the highlight will not appear.

Another reason - if you select a series on a pivot chart the corresponding
range does not highlight.

Also, if the source range is complex, for example a single series using
non-contiguous ranges will not display the highlight.

If the data series has been converted to values no range will be highlighted.
--
Cheers,
Shane Devenshire


"John" wrote:

Why don't Excel bounding boxes appear on some chart data sources? When I
click on some charts, they appear, while other charts they don't. What
setting controls this?