Pivot Table Charts

J

jjj

Hi,

Excel2000
I have a simple pivot table, which changes in size hen data i
refreshed. I want to create a bar graph which uses the info from it
but Excel automatically puts "drop-fields" into it with drop downs etc
wheras i dont want the user to be able to choose their fields. How ca
i creat a graph based on a pivot without having "drop-fields" in th
actual graph????

Help!

Many Thanks.

J
 
D

Debra Dalgleish

Excel2000
I have a simple pivot table, which changes in size hen data is
refreshed. I want to create a bar graph which uses the info from it,
but Excel automatically puts "drop-fields" into it with drop downs etc,
wheras i dont want the user to be able to choose their fields. How can
i creat a graph based on a pivot without having "drop-fields" in the
actual graph????
Click to expand...
 
Top