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.

" wrote:



hi,
did you try this
Toolsoptionsedit tabcheck 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