Thread: Getting line on line chart to display after creation from Pivot Table
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.charting
donnyj donnyj is offline
external usenet poster
  
Posts: 2
Default Getting line on line chart to display after creation from Pivot Table
On Feb 3, 2:10 pm, "Jon Peltier"
wrote:
Try to change how Excel deals with blank cells. In merged cells, all but the
top left cell of the merged area are considered blank. Tools menu Options
Chart, Plot Empty Cells As... Interpolate.

- Jon

This did the trick. Many thanks! -Donny

Reply With QuoteReply With Quote