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. |
How do I use a name in a range reference in excel?
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 |
How do I use a name in a range reference in excel?
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 |
All times are GMT +1. The time now is 09:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com