hide Drop Series Fields Here

[deb]

I have a pivot chart that does not need to use the Series drop area.

The Series drop area shows up on the chart - "Drop Series Fields Here"
Is there a way to make this go away and still keep the other drop filter
areas visible?

If I use the show/hide drop zones, it hides all areas.

That box that displays "Drop Series Fields Here" is very anoying

thanks,

 

[James]

I have a pivot chart that does not need to use the Series drop area.

The Series drop area shows up on the chart - "Drop Series Fields Here"
Is there a way to make this go away and still keep the other drop filter
areas visible?

If I use the show/hide drop zones, it hides all areas.  

That box that displays "Drop Series Fields Here" is very anoying

thanks,

Hi

Right click on your pivot table and select Properties | Behaviour |
Hide/Show Drop areas

Regards

 

[deb]

If I use the show/hide drop zones, it hides all areas.
I only want to hide the empty one. Series.

 

[Dan Norman]

 

[Dean]

I had the same problem. The best I could do was to make the dropzone white
(to be effectively invisible) and small in font size (to reduce the space it
takes up).

code at form load follows:

Private Sub Form_Load()

Dim dzSeriesDropZone
Dim chConstants

Set chtSpace = Me.Form.ChartSpace
Set chtChart = chtSpace.Charts(0)
Set chConstants = chtSpace.Constants

' Set a variable to the series drop zone in Chartspace1.
Set dzSeriesDropZone = chtSpace.DropZones(chConstants.chDropZoneSeries)

' The next three lines of code format the button of the drop zone.
dzSeriesDropZone.ButtonBorder.Weight = chConstants.owcLineWeightHairline
dzSeriesDropZone.ButtonInterior.SetSolid "Red"
dzSeriesDropZone.ButtonFont.Size = 6

' The next three lines of code format the watermark of the drop zone.
dzSeriesDropZone.WatermarkBorder.Color = chColorNone
dzSeriesDropZone.WatermarkFont.Color = "White"
dzSeriesDropZone.WatermarkFont.Size = 6
dzSeriesDropZone.WatermarkInterior.SetSolid "White"

' Allow properties box to be seen
Me.ChartSpace.AllowPropertyToolbox = True

End Sub

The lines that format the button are not needed. I just left them in so I
could remember them if I ever needed them.

 

[sam2000]

cspace.DisplayFieldButtons = false; //owc 2003 - to hide drop zones

This property will hide the drop zones.