View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
DOUG ECKERT[_2_] DOUG ECKERT[_2_] is offline
external usenet poster
 
Posts: 66
Default Hide future month's linked cells with value of zero

I have a linked chart built through the end of the fiscal year based on a
spreadsheet supplied by another office. WITHOUT hiding spreadsheet columns
or deleting cell content or changing chart coordinates, I would like to
instruct the chart not to plot future month's cells with zero values. Is
this possible?