Thread: Automatic Updating Charts

Just wondering if I could automatically change a chart.

For example I do a number of chart for every month, obviously days of the
months changes so on a month where there are 31st, there isnt a problem. The
problem is when i have a month which only has 30 or 28 days. This leaves the
last 3, 2 columns zero but are still on the chart but are shown as zero.

Does anyone know how to automatically adjust the source data? perhaps with
an if statement?

Thanks

tushar mehta and Jon peltier have excellent solution on this. you have to
make the source as dynamic array
see their webpages by searching in google


"Rich Gibbons" <RichGibbons@discussions.microsoft.com> wrote in message
news:230A3C17-95A7-44CD-BECE-737EB97780BD@microsoft.com...
> Just wondering if I could automatically change a chart.
>
> For example I do a number of chart for every month, obviously days of the
> months changes so on a month where there are 31st, there isnt a problem.
The
> problem is when i have a month which only has 30 or 28 days. This leaves
the
> last 3, 2 columns zero but are still on the chart but are shown as zero.
>
> Does anyone know how to automatically adjust the source data? perhaps with
> an if statement?
>
> Thanks
>

Here's an overview with a few examples and a lot of links:

http://peltiertech.com/Excel/Charts/Dynamics.html

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

R.VENKATARAMAN wrote:

> tushar mehta and Jon peltier have excellent solution on this. you have to
> make the source as dynamic array
> see their webpages by searching in google
>
>
> "Rich Gibbons" <RichGibbons@discussions.microsoft.com> wrote in message
> news:230A3C17-95A7-44CD-BECE-737EB97780BD@microsoft.com...
>
>>Just wondering if I could automatically change a chart.
>>
>>For example I do a number of chart for every month, obviously days of the
>>months changes so on a month where there are 31st, there isnt a problem.
>
> The
>
>>problem is when i have a month which only has 30 or 28 days. This leaves
>
> the
>
>>last 3, 2 columns zero but are still on the chart but are shown as zero.
>>
>>Does anyone know how to automatically adjust the source data? perhaps with
>>an if statement?
>>
>>Thanks
>>
>
>
>