Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Office 2007 Names - Why can't it start with Chart?
I have a workbook that has range names starting with Chart and other range
names that are offset from that one. I'm thinking at least 100 are affected. I know I can write a macro to change the names, and the series that use them, but why can't they start with Chart in Office 2007? This is going to be a lot of work to update. Thanks, Barb Reinhardt |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Office 2007 Names - Why can't it start with Chart?
I cannot replicate the problem.
I created 4 names, the first 3 being sheet level names and the last one a workbook level name. ChartBase =Sheet1!$F$1 ChartX =OFFSET(Sheet1!ChartBase,0,0,COUNTA(Sheet1!$F:$F), 1) ChartY =OFFSET(Sheet1!ChartX,0,1) ChartY2 =OFFSET(Sheet1!ChartX,0,2) Then, I created a Line chart with Sheet1!ChartX as the x values and Sheet1!ChartY and Book1!ChartY2 as the values of 2 series. Everything worked as expected. On Fri, 1 Aug 2008 11:30:01 -0700, Barb Reinhardt wrote: I have a workbook that has range names starting with Chart and other range names that are offset from that one. I'm thinking at least 100 are affected. I know I can write a macro to change the names, and the series that use them, but why can't they start with Chart in Office 2007? This is going to be a lot of work to update. Thanks, Barb Reinhardt Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Office 2007 Names - Why can't it start with Chart?
I know this is frustrating. It hardly makes sense to ask why, because the
answer will be along the lines of "because". I think it's probably an oversight. I don't know of a way to change the charts if they are already in 2007, but I'm thinking that it might not hurt to try writing a little macro.... Maybe if you check my blog in a few days. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Barb Reinhardt" wrote in message ... I have a workbook that has range names starting with Chart and other range names that are offset from that one. I'm thinking at least 100 are affected. I know I can write a macro to change the names, and the series that use them, but why can't they start with Chart in Office 2007? This is going to be a lot of work to update. Thanks, Barb Reinhardt |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Office 2007 Names - Why can't it start with Chart?
Tushar -
Did you try in Excel 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tushar Mehta" <ng_poster@tushar-underscore-mehta-dot-cee-oh-em wrote in message ... I cannot replicate the problem. I created 4 names, the first 3 being sheet level names and the last one a workbook level name. ChartBase =Sheet1!$F$1 ChartX =OFFSET(Sheet1!ChartBase,0,0,COUNTA(Sheet1!$F:$F), 1) ChartY =OFFSET(Sheet1!ChartX,0,1) ChartY2 =OFFSET(Sheet1!ChartX,0,2) Then, I created a Line chart with Sheet1!ChartX as the x values and Sheet1!ChartY and Book1!ChartY2 as the values of 2 series. Everything worked as expected. On Fri, 1 Aug 2008 11:30:01 -0700, Barb Reinhardt wrote: I have a workbook that has range names starting with Chart and other range names that are offset from that one. I'm thinking at least 100 are affected. I know I can write a macro to change the names, and the series that use them, but why can't they start with Chart in Office 2007? This is going to be a lot of work to update. Thanks, Barb Reinhardt Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Office 2007 Names - Why can't it start with Chart?
Jon,
I can put something together to create range names, delete range names and update the chart series. I don't need assistance with that, but thanks. What is the symptom in Office 2007? Can you not create range names starting with chart? If they are in a chart series, will they not display? Barb Reinhardt "Jon Peltier" wrote: I know this is frustrating. It hardly makes sense to ask why, because the answer will be along the lines of "because". I think it's probably an oversight. I don't know of a way to change the charts if they are already in 2007, but I'm thinking that it might not hurt to try writing a little macro.... Maybe if you check my blog in a few days. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Barb Reinhardt" wrote in message ... I have a workbook that has range names starting with Chart and other range names that are offset from that one. I'm thinking at least 100 are affected. I know I can write a macro to change the names, and the series that use them, but why can't they start with Chart in Office 2007? This is going to be a lot of work to update. Thanks, Barb Reinhardt |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Office 2007 Names - Why can't it start with Chart?
I don't recall the exact problem. I think you get an error, like a formula
references an invalid range, in an existing 2003 chart. In a new 2007 chart, it just doesn't accept the name as valid source data, and won't dismiss the dialog. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Barb Reinhardt" wrote in message ... Jon, I can put something together to create range names, delete range names and update the chart series. I don't need assistance with that, but thanks. What is the symptom in Office 2007? Can you not create range names starting with chart? If they are in a chart series, will they not display? Barb Reinhardt "Jon Peltier" wrote: I know this is frustrating. It hardly makes sense to ask why, because the answer will be along the lines of "because". I think it's probably an oversight. I don't know of a way to change the charts if they are already in 2007, but I'm thinking that it might not hurt to try writing a little macro.... Maybe if you check my blog in a few days. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Barb Reinhardt" wrote in message ... I have a workbook that has range names starting with Chart and other range names that are offset from that one. I'm thinking at least 100 are affected. I know I can write a macro to change the names, and the series that use them, but why can't they start with Chart in Office 2007? This is going to be a lot of work to update. Thanks, Barb Reinhardt |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Office 2007 Names - Why can't it start with Chart?
Yes, of course, Jon.
Is it possible you and Barb have some particular add-in installed that is causing the problem? On Sun, 3 Aug 2008 22:36:55 -0400, "Jon Peltier" wrote: Tushar - Did you try in Excel 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tushar Mehta" <ng_poster@tushar-underscore-mehta-dot-cee-oh-em wrote in message ... I cannot replicate the problem. I created 4 names, the first 3 being sheet level names and the last one a workbook level name. ChartBase =Sheet1!$F$1 ChartX =OFFSET(Sheet1!ChartBase,0,0,COUNTA(Sheet1!$F:$F), 1) ChartY =OFFSET(Sheet1!ChartX,0,1) ChartY2 =OFFSET(Sheet1!ChartX,0,2) Then, I created a Line chart with Sheet1!ChartX as the x values and Sheet1!ChartY and Book1!ChartY2 as the values of 2 series. Everything worked as expected. On Fri, 1 Aug 2008 11:30:01 -0700, Barb Reinhardt wrote: I have a workbook that has range names starting with Chart and other range names that are offset from that one. I'm thinking at least 100 are affected. I know I can write a macro to change the names, and the series that use them, but why can't they start with Chart in Office 2007? This is going to be a lot of work to update. Thanks, Barb Reinhardt Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Office 2007 Names - Why can't it start with Chart?
Interesting. I only recall testing this in the formula bar (a technique I
have used since about Excel 4), and not in the Select Source Data dialog, which I find in 2007 to be a huge step backwards compared to 2003. You cannot enter names beginning with "Chart" in the series formula: pressing Enter or the check button on the formula bar does nothing; the cursor keeps blinking in the formula. You can enter other names in the formula bar (I used TestX, TestY, and TestY2 and they worked just fine). You can enter these formulas in the Select Source Data dialog. Presumably then, existing names in charts should be okay in 2007, but you'd better test just in case. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tushar Mehta" <ng_poster@tushar-underscore-mehta-dot-cee-oh-em wrote in message ... Yes, of course, Jon. Is it possible you and Barb have some particular add-in installed that is causing the problem? On Sun, 3 Aug 2008 22:36:55 -0400, "Jon Peltier" wrote: Tushar - Did you try in Excel 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tushar Mehta" <ng_poster@tushar-underscore-mehta-dot-cee-oh-em wrote in message ... I cannot replicate the problem. I created 4 names, the first 3 being sheet level names and the last one a workbook level name. ChartBase =Sheet1!$F$1 ChartX =OFFSET(Sheet1!ChartBase,0,0,COUNTA(Sheet1!$F:$F), 1) ChartY =OFFSET(Sheet1!ChartX,0,1) ChartY2 =OFFSET(Sheet1!ChartX,0,2) Then, I created a Line chart with Sheet1!ChartX as the x values and Sheet1!ChartY and Book1!ChartY2 as the values of 2 series. Everything worked as expected. On Fri, 1 Aug 2008 11:30:01 -0700, Barb Reinhardt wrote: I have a workbook that has range names starting with Chart and other range names that are offset from that one. I'm thinking at least 100 are affected. I know I can write a macro to change the names, and the series that use them, but why can't they start with Chart in Office 2007? This is going to be a lot of work to update. Thanks, Barb Reinhardt Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
Office 2007 Names - Why can't it start with Chart?
Among the many things "not quite right" in 2007 is the usefulness of
the formula bar in working with charts. I stopped relying on it when I started using 2007 regularly. On Mon, 4 Aug 2008 15:18:22 -0400, "Jon Peltier" wrote: Interesting. I only recall testing this in the formula bar (a technique I have used since about Excel 4), and not in the Select Source Data dialog, which I find in 2007 to be a huge step backwards compared to 2003. You cannot enter names beginning with "Chart" in the series formula: pressing Enter or the check button on the formula bar does nothing; the cursor keeps blinking in the formula. You can enter other names in the formula bar (I used TestX, TestY, and TestY2 and they worked just fine). You can enter these formulas in the Select Source Data dialog. Presumably then, existing names in charts should be okay in 2007, but you'd better test just in case. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tushar Mehta" <ng_poster@tushar-underscore-mehta-dot-cee-oh-em wrote in message ... Yes, of course, Jon. Is it possible you and Barb have some particular add-in installed that is causing the problem? On Sun, 3 Aug 2008 22:36:55 -0400, "Jon Peltier" wrote: Tushar - Did you try in Excel 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tushar Mehta" <ng_poster@tushar-underscore-mehta-dot-cee-oh-em wrote in message ... I cannot replicate the problem. I created 4 names, the first 3 being sheet level names and the last one a workbook level name. ChartBase =Sheet1!$F$1 ChartX =OFFSET(Sheet1!ChartBase,0,0,COUNTA(Sheet1!$F:$F), 1) ChartY =OFFSET(Sheet1!ChartX,0,1) ChartY2 =OFFSET(Sheet1!ChartX,0,2) Then, I created a Line chart with Sheet1!ChartX as the x values and Sheet1!ChartY and Book1!ChartY2 as the values of 2 series. Everything worked as expected. On Fri, 1 Aug 2008 11:30:01 -0700, Barb Reinhardt wrote: I have a workbook that has range names starting with Chart and other range names that are offset from that one. I'm thinking at least 100 are affected. I know I can write a macro to change the names, and the series that use them, but why can't they start with Chart in Office 2007? This is going to be a lot of work to update. Thanks, Barb Reinhardt Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products |
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
Office 2007 Names - Why can't it start with Chart?
Considering how little of substance was really changed, it's a shame there
is so much "not quite right" with charting in 2007. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tushar Mehta" <ng_poster@tushar-underscore-mehta-dot-cee-oh-em wrote in message ... Among the many things "not quite right" in 2007 is the usefulness of the formula bar in working with charts. I stopped relying on it when I started using 2007 regularly. On Mon, 4 Aug 2008 15:18:22 -0400, "Jon Peltier" wrote: Interesting. I only recall testing this in the formula bar (a technique I have used since about Excel 4), and not in the Select Source Data dialog, which I find in 2007 to be a huge step backwards compared to 2003. You cannot enter names beginning with "Chart" in the series formula: pressing Enter or the check button on the formula bar does nothing; the cursor keeps blinking in the formula. You can enter other names in the formula bar (I used TestX, TestY, and TestY2 and they worked just fine). You can enter these formulas in the Select Source Data dialog. Presumably then, existing names in charts should be okay in 2007, but you'd better test just in case. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tushar Mehta" <ng_poster@tushar-underscore-mehta-dot-cee-oh-em wrote in message ... Yes, of course, Jon. Is it possible you and Barb have some particular add-in installed that is causing the problem? On Sun, 3 Aug 2008 22:36:55 -0400, "Jon Peltier" wrote: Tushar - Did you try in Excel 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tushar Mehta" <ng_poster@tushar-underscore-mehta-dot-cee-oh-em wrote in message ... I cannot replicate the problem. I created 4 names, the first 3 being sheet level names and the last one a workbook level name. ChartBase =Sheet1!$F$1 ChartX =OFFSET(Sheet1!ChartBase,0,0,COUNTA(Sheet1!$F:$F), 1) ChartY =OFFSET(Sheet1!ChartX,0,1) ChartY2 =OFFSET(Sheet1!ChartX,0,2) Then, I created a Line chart with Sheet1!ChartX as the x values and Sheet1!ChartY and Book1!ChartY2 as the values of 2 series. Everything worked as expected. On Fri, 1 Aug 2008 11:30:01 -0700, Barb Reinhardt wrote: I have a workbook that has range names starting with Chart and other range names that are offset from that one. I'm thinking at least 100 are affected. I know I can write a macro to change the names, and the series that use them, but why can't they start with Chart in Office 2007? This is going to be a lot of work to update. Thanks, Barb Reinhardt Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products |
#11
Posted to microsoft.public.excel.charting
|
|||
|
|||
Office 2007 Names - Why can't it start with Chart?
I could not agree more!
Jon Peltier wrote: Considering how little of substance was really changed, it's a shame there is so much "not quite right" with charting in 2007. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tushar Mehta" <ng_poster@tushar-underscore-mehta-dot-cee-oh-em wrote in message ... Among the many things "not quite right" in 2007 is the usefulness of the formula bar in working with charts. I stopped relying on it when I started using 2007 regularly. On Mon, 4 Aug 2008 15:18:22 -0400, "Jon Peltier" wrote: Interesting. I only recall testing this in the formula bar (a technique I have used since about Excel 4), and not in the Select Source Data dialog, which I find in 2007 to be a huge step backwards compared to 2003. You cannot enter names beginning with "Chart" in the series formula: pressing Enter or the check button on the formula bar does nothing; the cursor keeps blinking in the formula. You can enter other names in the formula bar (I used TestX, TestY, and TestY2 and they worked just fine). You can enter these formulas in the Select Source Data dialog. Presumably then, existing names in charts should be okay in 2007, but you'd better test just in case. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tushar Mehta" <ng_poster@tushar-underscore-mehta-dot-cee-oh-em wrote in message ... Yes, of course, Jon. Is it possible you and Barb have some particular add-in installed that is causing the problem? On Sun, 3 Aug 2008 22:36:55 -0400, "Jon Peltier" wrote: Tushar - Did you try in Excel 2007? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tushar Mehta" <ng_poster@tushar-underscore-mehta-dot-cee-oh-em wrote in message ... I cannot replicate the problem. I created 4 names, the first 3 being sheet level names and the last one a workbook level name. ChartBase =Sheet1!$F$1 ChartX =OFFSET(Sheet1!ChartBase,0,0,COUNTA(Sheet1!$F:$F), 1) ChartY =OFFSET(Sheet1!ChartX,0,1) ChartY2 =OFFSET(Sheet1!ChartX,0,2) Then, I created a Line chart with Sheet1!ChartX as the x values and Sheet1!ChartY and Book1!ChartY2 as the values of 2 series. Everything worked as expected. On Fri, 1 Aug 2008 11:30:01 -0700, Barb Reinhardt wrote: I have a workbook that has range names starting with Chart and other range names that are offset from that one. I'm thinking at least 100 are affected. I know I can write a macro to change the names, and the series that use them, but why can't they start with Chart in Office 2007? This is going to be a lot of work to update. Thanks, Barb Reinhardt Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel in Office 2007 fails to start ... | Setting up and Configuration of Excel | |||
Excel in office 2007 fails to start.. HELP pls | Setting up and Configuration of Excel | |||
Open File on PC Start Up (Office 2007) | Excel Discussion (Misc queries) | |||
Office 2007 Configuration wizard runs every time I start anyApplication (word, excel, etc) | Setting up and Configuration of Excel | |||
Office 2007 - How do you add data to a chart? | Charts and Charting in Excel |