Pivotdiagrams

[Prebbe]

I have a pivottable with 5 different coloumns, but I want
to use only two of them in a diagram. How is this
possible??? The only thing I've managed to do, is a
diagram with all five coloumns...... Need help quick!

 

[Debra Dalgleish]

You can create a normal chart from a Pivot Table. There are instructions
on Jon Peltier's web site:

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

Follow the instructions, and include only the two columns you want.