autoupdating charts

[c991257]

Hi

In a weekly progress report I would update a quantity performed which in turn updates an accumulated quantity.

Instead of presenting the data I present a chart showing the performance. My problem is that everytime I add data I have to change the source data in the chart and add the weeks cells to include those.

Is there a way around that so that I only have to enter the data and the chart automatically takes the new data into consideration?

/Møller

[Tim]

Check out http://peltiertech.com/Excel/Charts/...umnChart1.html. It
not only has a good example of this type of dynamic charting, it also has an
example for how to limit the chart to a date range as well.

The technique relies on the OFFSET function and named ranges.

WARNING: Once you start using this technique, you'll never stop!

"c991257" wrote:

>
> Hi
>
> In a weekly progress report I would update a quantity performed which
> in turn updates an accumulated quantity.
>
> Instead of presenting the data I present a chart showing the
> performance. My problem is that everytime I add data I have to change
> the source data in the chart and add the weeks cells to include those.
>
> Is there a way around that so that I only have to enter the data and
> the chart automatically takes the new data into consideration?
>
> /Møller
>
>
> --
> c991257
> ------------------------------------------------------------------------
> c991257's Profile: http://www.excelforum.com/member.php...o&userid=36549
> View this thread: http://www.excelforum.com/showthread...hreadid=568507
>
>