View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Charts using hidden cells

Perhaps another sheet or put the range behind the chart.

--
Don Guillett
SalesAid Software

"TheRook" wrote in message
...
Is it possible to use hidden cells for the source data on a chart.

At present I have several charts set up which work correctly but is I hide
the data it is using the charts turn blank.

regards