hide Drop Series Fields Here

  • Thread starter Thread starter deb
  • Start date Start date
D

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,
 
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,
Click to expand...

Hi

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

Regards
 
If I use the show/hide drop zones, it hides all areas.
I only want to hide the empty one. Series.
 
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.
 
cspace.DisplayFieldButtons = false; //owc 2003 - to hide drop zones

This property will hide the drop zones.
 
Back
Top