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