ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   line chart plots false value and the real value on same date (https://www.excelbanter.com/charts-charting-excel/255890-line-chart-plots-false-value-real-value-same-date.html)

IsaBeL

line chart plots false value and the real value on same date
 
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!!


All times are GMT +1. The time now is 03:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com