Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,344
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I enlarge the spreadsheet that has no sizing handles? Kathy975 Setting up and Configuration of Excel 2 July 13th 06 11:28 PM
Chart resizing handles Sarge Charts and Charting in Excel 2 January 30th 06 09:09 PM
Button sizing handles do not appear alex Excel Worksheet Functions 3 May 27th 05 03:51 PM
Sizing handles on my chart titles don't work! Nicole Charts and Charting in Excel 2 March 4th 05 06:14 AM
The 'sizing handles' on the axis titles don't work!! Nicole Charts and Charting in Excel 1 March 4th 05 12:11 AM


All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"