ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart Sizing Handles (https://www.excelbanter.com/charts-charting-excel/192827-chart-sizing-handles.html)

Brian Gardner

Chart Sizing Handles
 
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 as this
is a work-related issue. Thanks.

Jon Peltier

Chart Sizing Handles
 
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 wrote in message
...
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
as
this
is a work-related issue. Thanks.




ShaneDevenshire

Chart Sizing Handles
 
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 as this
is a work-related issue. Thanks.


Jon Peltier

Chart Sizing Handles
 
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" wrote in
message ...
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 as
this
is a work-related issue. Thanks.





All times are GMT +1. The time now is 05:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com