How do I use a name in a range reference in excel?

I have a excel file that has a table with columns for each month of the year,
and has many charts showing the row data for the range from january to
whatever the current month is. How can I use a name such as "current_month"
in the range reference for the chart rather than a specific column reference
that has to be changed in multiple places each month? I'd like to just
update the name in one place and have the charts automaitcally show the
proper range.

Hi,

You will find some information here,
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html

Cheers
Andy

RicRob wrote:
> I have a excel file that has a table with columns for each month of the year,
> and has many charts showing the row data for the range from january to
> whatever the current month is. How can I use a name such as "current_month"
> in the range reference for the chart rather than a specific column reference
> that has to be changed in multiple places each month? I'd like to just
> update the name in one place and have the charts automaitcally show the
> proper range.

--

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

Thanks. This stuff looks like it should be useful. I'll give it a try.

"Andy Pope" wrote:

> Hi,
>
> You will find some information here,
> http://peltiertech.com/Excel/Charts/Dynamics.html
> http://www.tushar-mehta.com/excel/ne...rts/index.html
>
> Cheers
> Andy
>
> RicRob wrote:
> > I have a excel file that has a table with columns for each month of the year,
> > and has many charts showing the row data for the range from january to
> > whatever the current month is. How can I use a name such as "current_month"
> > in the range reference for the chart rather than a specific column reference
> > that has to be changed in multiple places each month? I'd like to just
> > update the name in one place and have the charts automaitcally show the
> > proper range.
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>