View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Whitney Whitney is offline
external usenet poster
 
Posts: 40
Default connect line to data points with missing data in between

Care to share with the rest of us how you did it??


"ziak" wrote:

NEVERMIND! figured it out...

"ziak" wrote:

Hi All:

I have 10 years worth of currency data that i need to graph by month. Many
months do not have any data - adding a "zero" makes the line plummet to zero.
Keeping it blank leaves a missing space between the previous and next data
points.

How do I connect the line with missing data points in between?

Thanks!!