Why can't I resize/move objects in XL XP chart?

[tjak]

I've checked every spot I can find locally to ensure that click and drag is
activated without success.

hi,
did you try this
Tools>options>edit tab>check allow cell drag and drop

>-----Original Message-----
>I've checked every spot I can find locally to ensure that
click and drag is
>activated without success.
>.
>

[tjak]

Yes, first thing. It works elsewhere but not in charts. I can't even get the
tw0-heded arrow. I've heard someone else (not at this location) had the same
problem and couldn't get it working.

"anonymous@discussions.microsoft.com" wrote:

> hi,
> did you try this
> Tools>options>edit tab>check allow cell drag and drop
>
> >-----Original Message-----
> >I've checked every spot I can find locally to ensure that
> click and drag is
> >activated without success.
> >.
> >
>

[Jon Peltier]

Is the workbook shared? Among other features, working with charts is severely
hobbled in shared workbooks.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

tjak wrote:

> Yes, first thing. It works elsewhere but not in charts. I can't even get the
> tw0-heded arrow. I've heard someone else (not at this location) had the same
> problem and couldn't get it working.
>
> "anonymous@discussions.microsoft.com" wrote:
>
>
>>hi,
>>did you try this
>>Tools>options>edit tab>check allow cell drag and drop
>>
>>
>>>-----Original Message-----
>>>I've checked every spot I can find locally to ensure that
>>
>>click and drag is
>>
>>>activated without success.
>>>.
>>>
>>

[tjak]

I have since found that in XP, chart elements are locked by Microsoft. So my
question has become: How can I create a chart without going through
PivotChart? (So far I keep getting automatically put into PivotChart.) OR
does anyone have a work-around for this? I hope I'm not the first/only person
with this challenge.

"Jon Peltier" wrote:

> Is the workbook shared? Among other features, working with charts is severely
> hobbled in shared workbooks.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> tjak wrote:
>
> > Yes, first thing. It works elsewhere but not in charts. I can't even get the
> > tw0-heded arrow. I've heard someone else (not at this location) had the same
> > problem and couldn't get it working.
> >
> > "anonymous@discussions.microsoft.com" wrote:
> >
> >
> >>hi,
> >>did you try this
> >>Tools>options>edit tab>check allow cell drag and drop
> >>
> >>
> >>>-----Original Message-----
> >>>I've checked every spot I can find locally to ensure that
> >>
> >>click and drag is
> >>
> >>>activated without success.
> >>>.
> >>>
> >>
>
>

[Debra Dalgleish]

There are instructions on Jon Peltier's site for creating a normal chart
from pivot data:

http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm


tjak wrote:
> I have since found that in XP, chart elements are locked by Microsoft. So my
> question has become: How can I create a chart without going through
> PivotChart? (So far I keep getting automatically put into PivotChart.) OR
> does anyone have a work-around for this? I hope I'm not the first/only person
> with this challenge.
>
> "Jon Peltier" wrote:
>
>
>>Is the workbook shared? Among other features, working with charts is severely
>>hobbled in shared workbooks.
>>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>Peltier Technical Services
>>Tutorials and Custom Solutions
>>http://PeltierTech.com/
>>_______
>>
>>tjak wrote:
>>
>>
>>>Yes, first thing. It works elsewhere but not in charts. I can't even get the
>>>tw0-heded arrow. I've heard someone else (not at this location) had the same
>>>problem and couldn't get it working.
>>>
>>>"anonymous@discussions.microsoft.com" wrote:
>>>
>>>
>>>
>>>>hi,
>>>>did you try this
>>>>Tools>options>edit tab>check allow cell drag and drop
>>>>
>>>>
>>>>
>>>>>-----Original Message-----
>>>>>I've checked every spot I can find locally to ensure that
>>>>
>>>>click and drag is
>>>>
>>>>
>>>>>activated without success.
>>>>>.
>>>>>
>>>>
>>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html