Automatically vary range in graph depending on #rows data entered?
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. |
Automatically vary range in graph depending on #rows data entered?
Dynamic Charts:
http://peltiertech.com/WordPress/200...ynamic-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" wrote in message ... 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. |
All times are GMT +1. The time now is 12:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com