Chart Sizing Handles
in [Charts]
|
Prev: Excel 2003: How to nudge a chart element or shape on a chart?
Next: i can't see a chart i made, all i get is blue worksheet
From: Brian Gardner Brian on 26 Jun 2008 16:35 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 brian.gardner(a)curascript.com as this is a work-related issue. Thanks.
From: Jon Peltier on 26 Jun 2008 18:35 This blog entry might be informative: Highlighted Chart Source Data http://peltiertech.com/WordPress/2008/05/27/highlighted-chart-source-data/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Brian Gardner" <Brian Gardner(a)discussions.microsoft.com> wrote in message news:1CC2FFD9-1B98-4078-BFA1-F4CB0338AC48(a)microsoft.com... > 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 brian.gardner(a)curascript.com as > this > is a work-related issue. Thanks.
From: ShaneDevenshire on 28 Jun 2008 13:26 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 brian.gardner(a)curascript.com as this > is a work-related issue. Thanks.
From: Jon Peltier on 28 Jun 2008 15:16
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" <ShaneDevenshire(a)discussions.microsoft.com> wrote in message news:54E9B6C6-1D84-47C1-8B96-9E864C3ECD37(a)microsoft.com... > 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 brian.gardner(a)curascript.com as >> this >> is a work-related issue. Thanks. |