From: JR Hester on 9 Feb 2010 17:15 John, Thanks for this post, between this forum and your Chart the last 12 months on your website, i was able to solve a problem for one of my coworkers. "Jon Peltier" wrote: > Option A: Use an Excel 2007 Table (like an Excel 2003 List on steroids) as > the data source. > > Option B: Use dynamic ranges as the source data: > > http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html > http://peltiertech.com/Excel/Charts/Dynamics.html > > - Jon > ------- > Jon Peltier, Microsoft Excel MVP > Tutorials and Custom Solutions > Peltier Technical Services, Inc. - http://PeltierTech.com > _______ > > > "dave01" <dave01(a)discussions.microsoft.com> wrote in message > news:F340A12B-1A1F-4A50-904F-261D386EB5B6(a)microsoft.com... > >I have moved over to excel 2007 and cannot work out how to create a chart > > that updates automatically. Can anyone help ? > > >
|
Pages: 1 Prev: Hidden and Empty Cell Settings Next: Replace Series Marker With Double Headed Arrow |