When a chart is created it usually has a series of boxes that encompass the
data contained in the chart much like it does with a SUM function. If these
boxes disappear, how can I get them back?

Please copy replies to this question to (E-Mail Removed) as this
is a work-related issue. Thanks.

This blog entry might be informative:

Highlighted Chart Source Data
http://peltiertech.com/WordPress/200...t-source-data/


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Brian Gardner" <Brian (E-Mail Removed)> wrote in message
news:1CC2FFD9-1B98-4078-BFA1-(E-Mail Removed)...
> When a chart is created it usually has a series of boxes that encompass
> the
> data contained in the chart much like it does with a SUM function. If
> these
> boxes disappear, how can I get them back?
>
> Please copy replies to this question to (E-Mail Removed) as
> this
> is a work-related issue. Thanks.

Hi Brian,

Pivot charts don't highlght the range when a series is selected.

But for most other chart to see the highlight you must have the series
selected on the chart keeping in mind Jon's points.

--
Cheers,
Shane Devenshire


"Brian Gardner" wrote:

> When a chart is created it usually has a series of boxes that encompass the
> data contained in the chart much like it does with a SUM function. If these
> boxes disappear, how can I get them back?
>
> Please copy replies to this question to (E-Mail Removed) as this
> is a work-related issue. Thanks.

Shane -

You can see the entire source data range, if it's not "too complex" to show
in the dialog. The plot area or chart area must be selected to show this
entire range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"ShaneDevenshire" <(E-Mail Removed)> wrote in
message news:54E9B6C6-1D84-47C1-8B96-(E-Mail Removed)...
> Hi Brian,
>
> Pivot charts don't highlght the range when a series is selected.
>
> But for most other chart to see the highlight you must have the series
> selected on the chart keeping in mind Jon's points.
>
> --
> Cheers,
> Shane Devenshire
>
>
> "Brian Gardner" wrote:
>
>> When a chart is created it usually has a series of boxes that encompass
>> the
>> data contained in the chart much like it does with a SUM function. If
>> these
>> boxes disappear, how can I get them back?
>>
>> Please copy replies to this question to (E-Mail Removed) as
>> this
>> is a work-related issue. Thanks.