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"
<jonxlmvpNO RemoveThis @SPAMpeltiertech.com> 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 news:e3ae94lg1s8uk7nuk2t6s7sudb7ga66rir@4ax.com...
> 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"
> <jonxlmvpNO RemoveThis @SPAMpeltiertech.com> 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 news:cgkc94dik87dmieu7ui62fg1vcrjil5dm8@4ax.com...
>>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
>> <BarbReinhardt RemoveThis @discussions.microsoft.com> 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

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 news:61tg94l4ie85ibanvelga9og737om0m2u0@4ax.com...
> 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"
> <jonxlmvpNO.TakeThisOut@SPAMpeltiertech.com> 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 news:e3ae94lg1s8uk7nuk2t6s7sudb7ga66rir@4ax.com...
>> 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"
>> <jonxlmvpNO.TakeThisOut@SPAMpeltiertech.com> 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 news:cgkc94dik87dmieu7ui62fg1vcrjil5dm8@4ax.com...
>>>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
>>> <BarbReinhardt.TakeThisOut@discussions.microsoft.com> 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