I would like the chart to update automatically when monthly data i
entered.

Every 1st of the month I update the data to add previous monthl
values.

I like the chart to update automatically.
And, I want my chart to show only past 12 month period data. It mean
every month when I add excel data, the chart should automatically dro
the the first month values and add last month.

It's a line chart.

Any input is appreciated

--
Message posted from http://www.ExcelForum.com

Hi NYBoy,

Check out Jon Peltier's example.
http://peltiertech.com/Excel/Charts/DynamicLast12.html

Cheers
Andy

NYBoy < wrote:

> I would like the chart to update automatically when monthly data is
> entered.
>
> Every 1st of the month I update the data to add previous monthly
> values.
>
> I like the chart to update automatically.
> And, I want my chart to show only past 12 month period data. It means
> every month when I add excel data, the chart should automatically drop
> the the first month values and add last month.
>
> It's a line chart.
>
> Any input is appreciated.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hi Andy, I did that example.
But, my spreadhseet might be little complicated. Could you please look
at it if I send it to you. And, tell me how can talk to you privately.
Is there live chat available ?


---
Message posted from http://www.ExcelForum.com/

Hi,

Email me privately with an example and I will have a look.

Cheers
Andy

NYBoy < wrote:

> Hi Andy, I did that example.
> But, my spreadhseet might be little complicated. Could you please look
> at it if I send it to you. And, tell me how can talk to you privately.
> Is there live chat available ?
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy, You will have to give me your email address. I'll send attachment
through my yahoo.com email.
I can't seem to remeber my login account email/password.

Thanks


---
Message posted from http://www.ExcelForum.com/