Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Chart with Defined names
Hi,
I have set up defined names for a range of data, for example "dates" :- =OFFSET(Data!$A$1,COUNTA(Data!$A:$A)-22,0,22) and I have set the series of the x-axis of my chart to:- ="filename"!dates However, when I go back to the file the series name has been changed to the following:- =[0]!dates so that the chart no longer looks at the latest range anymore. I change the name of the sheets/tabs after the names were defined and the chart was created, would this create the problem? Has anyone come accross this problem, any help is appreciated. Many thanks, Nils |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Chart with Defined names
When inputting the defined name into your series, use single quotes, not
double: ='My Book.xls'!dates -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Nils" wrote: Hi, I have set up defined names for a range of data, for example "dates" :- =OFFSET(Data!$A$1,COUNTA(Data!$A:$A)-22,0,22) and I have set the series of the x-axis of my chart to:- ="filename"!dates However, when I go back to the file the series name has been changed to the following:- =[0]!dates so that the chart no longer looks at the latest range anymore. I change the name of the sheets/tabs after the names were defined and the chart was created, would this create the problem? Has anyone come accross this problem, any help is appreciated. Many thanks, Nils |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Chart with Defined names
thanks for your response.
My original post is incorrect, I used single quotation marks in my chart:- ='filename.xlsx'!dates Sorry for the confusion! Nils "Luke M" wrote: When inputting the defined name into your series, use single quotes, not double: ='My Book.xls'!dates -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Nils" wrote: Hi, I have set up defined names for a range of data, for example "dates" :- =OFFSET(Data!$A$1,COUNTA(Data!$A:$A)-22,0,22) and I have set the series of the x-axis of my chart to:- ="filename"!dates However, when I go back to the file the series name has been changed to the following:- =[0]!dates so that the chart no longer looks at the latest range anymore. I change the name of the sheets/tabs after the names were defined and the chart was created, would this create the problem? Has anyone come accross this problem, any help is appreciated. Many thanks, Nils |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Chart with Defined names
Have you installed any service packs to your Office 2007 installation?
It's up to SP2. This was a problem when 2007 first came out, but I have not encountered it for a while. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Nils wrote: Hi, I have set up defined names for a range of data, for example "dates" :- =OFFSET(Data!$A$1,COUNTA(Data!$A:$A)-22,0,22) and I have set the series of the x-axis of my chart to:- ="filename"!dates However, when I go back to the file the series name has been changed to the following:- =[0]!dates so that the chart no longer looks at the latest range anymore. I change the name of the sheets/tabs after the names were defined and the chart was created, would this create the problem? Has anyone come accross this problem, any help is appreciated. Many thanks, Nils |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Chart with Defined names
Thanks Jon,
I think this might be the problem, however it's a work PC so it will have to go through IT dept to be updated and I'm not sure that would happen! I have used a work around, using the "large" function for the largest range of dates and then V-lookup to pick up the corresponding data. "Jon Peltier" wrote: Have you installed any service packs to your Office 2007 installation? It's up to SP2. This was a problem when 2007 first came out, but I have not encountered it for a while. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Nils wrote: Hi, I have set up defined names for a range of data, for example "dates" :- =OFFSET(Data!$A$1,COUNTA(Data!$A:$A)-22,0,22) and I have set the series of the x-axis of my chart to:- ="filename"!dates However, when I go back to the file the series name has been changed to the following:- =[0]!dates so that the chart no longer looks at the latest range anymore. I change the name of the sheets/tabs after the names were defined and the chart was created, would this create the problem? Has anyone come accross this problem, any help is appreciated. Many thanks, Nils . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Chart with OFFSET defined name not working | Charts and Charting in Excel | |||
Excel 2007 - Dynamic names for chart series | Charts and Charting in Excel | |||
dynamic XY chart names | Excel Discussion (Misc queries) | |||
Dynamic Step Chart using range names | Charts and Charting in Excel | |||
Using Defined Names in a Chart | Excel Discussion (Misc queries) |