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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Named Ranges in Chart Series 1
Copy a group of Chart tabs 2
Using a 'Name' to Update Chart Titles & "Y" Axis Scale 2
Loss of referenced data (Titles) when upgrading from Excel 2000 to2007 1
Excel 2007 graphs/charts automatically populate with new data 1
VBA code to copy named range in closed workbook 2
Charts - Setting Data Area as a Variable 1
Can you make a chart's data *always* refer to a dynamic range name? 2

Top