line chart plots false value and the real value on same date

I

Isabel

I have encountered a strange 'fault' on my line chart; on just three
adjacent dates, the value that is plotted is double: one real value, and the
second a phantom value (Not even existing in the data!), with the result
that the line 'spikes' up and down on these three days, and continues with
the correct data. Help please!!
 

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

Excel line chart not displaying correctly 1
Plotting a current Date Vertical Line 2
Values plotted incorrectly on Line Chart 3
plotting line charts with formula based 'gaps' 11
Excel 2007: Lines not displaying on Scatter Plots 1
Excel 2007: Lines not displaying on Scatter Plots 0
Chart does not render plotted points correctly, data comes from a 3
XY charts: can't plot Y vs. value of X 3

Top