Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Using a range variable inside a excel function | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Page Range Printing Problems | Excel Discussion (Misc queries) | |||
Multiple reference for lookup in excel | Excel Worksheet Functions |