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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top