plotting a chart, disregarding certain values.

[Tacixa]

Hi all,

I am trying to create a workbook that plots a line chart of two data sets. the problem i am running into is that some of the time-stamps from one set will not match up with the others, and thus need to be ignored. i managed to do this with if statements easily, and currently, any non matching time and value is replaced by NA(). however, as i am trying to make this workbook future-proof, i want the chart to plot any non NA() value over 20,000 rows.

Currently, the axis including all the NA() in its min and max values (meaning that the data is scaled to fit on only 1/10th of the overall plotting area, and the rest is empty).

Is there any way to avoid this from happening without using pivot tables or VBA?

Regards,

Tacixa

 

[ask2tsp]

Consider organizing the data in one table, leaving cells empty when there is no data and then use a scatter plot, X=dates, Y1=1st data series, Y2=2nd data series.