Prev: Hiding Pie Slice When Value is Zero
Next: Edit Chart to Change Source Data
From: dalek on 1 Jul 2008 16:53
I want to set up a chart so that the range of values entered in the Source
Data dialog box automatically changes depending on a count of the number of
rows of data that has been pasted into worksheet of source data. Can I embed
a link to a cell with the number representing the number of rows. For
example, in =Data!$H$2:$H$70, I want the "70" to vary depending on how many
rows of data have been pasted. For Excel 2002 and/or2007.
From: Jon Peltier on 1 Jul 2008 23:45
Dynamic Charts:
http://peltiertech.com/WordPress/2008/05/14/dynamic-charts/
http://peltiertech.com/Excel/Charts/Dynamics.html

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


"dalek" <dalek(a)discussions.microsoft.com> wrote in message
news:861C8819-EC84-4581-B0A9-7CFBA15BD15D(a)microsoft.com...
>I want to set up a chart so that the range of values entered in the Source
> Data dialog box automatically changes depending on a count of the number
> of
> rows of data that has been pasted into worksheet of source data. Can I
> embed
> a link to a cell with the number representing the number of rows. For
> example, in =Data!$H$2:$H$70, I want the "70" to vary depending on how
> many
> rows of data have been pasted. For Excel 2002 and/or2007.


 | 
Pages: 1
Prev: Hiding Pie Slice When Value is Zero
Next: Edit Chart to Change Source Data