View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tobias[_2_] Tobias[_2_] is offline
external usenet poster
 
Posts: 11
Default Hide zero column in Pivotreport

Hello all

I have a number of process sections that I keep track of. It is how much was produced in each section per week. When I want to create a chart from this it would be nice to hide the zero columns. (Containing the weeks when nothing was produced.) I have a script for hiding zero rows, but I'm not able to transform it to columns also

Thanks in advance.