Excel 2003 - interrupted data

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

Hello

Can someone explain to me how to create a line graph chart of a time series
where there are gaps in the data? I have daily data over two years, but there
are gaps. Excel seems to connect the last data point before a gap to the next
data point after the gap.

Many thanks in advance and kind regards

Nick
 
Is the gap comprised of actually blank cells, or formulas that return
something that looks like a blank? If the cells are truly blank, go to Tools
menu > Options > Chart tab, and choose the 'Not Plotted' option for dealing
with blank cells.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the full width of an Excel chart with two Y-axes 2
Excel 2007: Line where a gap should be, but only when plotting on ahorizontal date axis 2
Help with "clusters" of plotted data 2
excel "no data" labeling in bar graph 3
surface chart 1
Discontinuous lines in series due to gaps in data points 2
Excel (2007) won't do a particular X-Y (Point) graph for me.. 9
Remove Space on Bar Charts for Missing Data 2

Back
Top