Automatic Updating Charts

#1 10-06-2005, 08:05 AM

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

#2 10-07-2005, 01:05 AM

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
>

#3 10-09-2005, 08:05 PM

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
>>
>
>
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)