Auto expanding X Axis for Chart
in [Charts]
|
Prev: How to set each gruop of columns into same color?
Next: Changing ChartTypes will not change the color of the Series
From: Corey on 7 Mar 2010 18:02 I have a chart setup, currently with reference to 31 cells width. The chart looks great if the user places a value in each of the 31 cells, however if there are only say 20 values placed across the cell row, the chart is displayed over to one side, with nil values displayed where no dat values were entered. Is there a way to have the chart automatically vary the width depending on the amount of values entered across the refernced row of cells? If there was only 20 values entered, then the chart would show 1-20 charted and leave out the 21-31. Corey....
From: trip_to_tokyo on 8 Mar 2010 00:12 EXCEL 2007 Hi Corey take a look at:- http://www.pierrefondes.com/ - item number 72. This is a similar problem. You don't say what's on the X axis so I am nut sure whether or not this example will help. In the example I have given the X axis was set to:- Text axis - and this removed the Sundays from the data shown on the graph. If my comments have helped please hit Yes. Thanks. "Corey" wrote: > I have a chart setup, currently with reference to 31 cells width. > > The chart looks great if the user places a value in each of the 31 cells, > however if there are only say 20 values placed across the cell row, the > chart is displayed over to one side, with nil values displayed where no dat > values were entered. > > Is there a way to have the chart automatically vary the width depending on > the amount of values entered across the refernced row of cells? > > If there was only 20 values entered, then the chart would show 1-20 charted > and leave out the 21-31. > > > Corey.... > > > . >
From: Simeon on 8 Mar 2010 05:17 What you need is dynamic range if I understand your problem right. Name your data range as a dynamic range , and in the series of the chart put the range name. Google how to do dynamic range, I don't remember on the top of my head any website, but basically is done *RangeName * *=Offset($A$1, 0,0, Counta(A:A), Counta($1:$1)*) ,then in chart data series you put =sheet1!RangeName Of course this needs to be customized for your particular range. If done right, it'll chart only the cells with data, leaving the blank cells. Hope that will give you the right direction. Again try googling it - there is tons of websites explaining this technique Sam PS. To Trip_to_tokio - noob question, but I am using mozila thunderbird client, where do you hit yes?! On 3/7/2010 9:12 PM, trip_to_tokyo wrote: > EXCEL 2007 > > Hi Corey take a look at:- > > http://www.pierrefondes.com/ > > - item number 72. > > This is a similar problem. > > You don't say what's on the X axis so I am nut sure whether or not this > example will help. > > In the example I have given the X axis was set to:- > > Text axis > > - and this removed the Sundays from the data shown on the graph. > > If my comments have helped please hit Yes. > > Thanks. > > > > "Corey" wrote: > > >> I have a chart setup, currently with reference to 31 cells width. >> >> The chart looks great if the user places a value in each of the 31 cells, >> however if there are only say 20 values placed across the cell row, the >> chart is displayed over to one side, with nil values displayed where no dat >> values were entered. >> >> Is there a way to have the chart automatically vary the width depending on >> the amount of values entered across the refernced row of cells? >> >> If there was only 20 values entered, then the chart would show 1-20 charted >> and leave out the 21-31. >> >> >> Corey.... >> >> >> . >> >>
From: Jon Peltier on 9 Mar 2010 09:56
> PS. To Trip_to_tokio - noob question, but I am using mozila > thunderbird client, where do you hit yes?! Ignore this, it's only relevant to users of the wonderful Microsoft web interface to the newsgroups. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 3/8/2010 5:17 AM, Simeon wrote: > What you need is dynamic range if I understand your problem right. Name > your data range as a dynamic range , and in the series of the chart put > the range name. Google how to do dynamic range, I don't remember on the > top of my head any website, but basically is done *RangeName * > *=Offset($A$1, 0,0, Counta(A:A), Counta($1:$1)*) ,then in chart data > series you put =sheet1!RangeName > Of course this needs to be customized for your particular range. If done > right, it'll chart only the cells with data, leaving the blank cells. > Hope that will give you the right direction. > Again try googling it - there is tons of websites explaining this > technique > > Sam > > > On 3/7/2010 9:12 PM, trip_to_tokyo wrote: >> EXCEL 2007 >> >> Hi Corey take a look at:- >> >> http://www.pierrefondes.com/ >> >> - item number 72. >> >> This is a similar problem. >> >> You don't say what's on the X axis so I am nut sure whether or not this >> example will help. >> >> In the example I have given the X axis was set to:- >> >> Text axis >> >> - and this removed the Sundays from the data shown on the graph. >> >> If my comments have helped please hit Yes. >> >> Thanks. >> >> >> >> "Corey" wrote: >> >> >>> I have a chart setup, currently with reference to 31 cells width. >>> >>> The chart looks great if the user places a value in each of the 31 cells, >>> however if there are only say 20 values placed across the cell row, the >>> chart is displayed over to one side, with nil values displayed where no dat >>> values were entered. >>> >>> Is there a way to have the chart automatically vary the width depending on >>> the amount of values entered across the refernced row of cells? >>> >>> If there was only 20 values entered, then the chart would show 1-20 charted >>> and leave out the 21-31. >>> >>> >>> Corey.... >>> >>> >>> . >>> >>> |