Plotting Chart data Accurately

[Mike Slattery]

I have several columns of stock data including the date. All data for all dates that are not high or low for a given period have been removed.
I wish to plot this zig zag line that alternates between the last top and the next bottom on a pre existing chart that contains all of the historical date and price data.

Is there a way to get this reduced data-set with far fewer dates to plot correctly across the X-Axis?

 

[cyrilbrd]

I have several columns of stock data including the date. All data for all dates that are not high or low for a given period have been removed...

replace blanks with #N/A, so within your formula use =NA()

...Is there a way to get this reduced data-set with far fewer dates to plot correctly across the X-Axis?

yes, choose dates as X axis, and it will be charted properly as it will hold the same number of rows.

 

[Mike Slattery]

There is a flag that is generated producing a 1 if the stock is at a top and a 2 if it is at a bottom. I need to eliminate all cell/records that have repeated values of 1 or 2's producing a zig zag of nothing but sequential records with 1,2,1,2 and never 1,1,2,1,2,2,2,1,1, etc.

Are you suggesting that instead of eliminating those records I just write over their contents with #N/A().

Thanks, for your assistance,

Michael

 

[cyrilbrd]

...Are you suggesting that instead of eliminating those records I just write over their contents with #N/A()...

Yes.
In your formula, replace the "" with NA().
Such would allow a 'zig-zag' effect once plotted on a chart.

 

[Mike Slattery]

Thanks, Michael

 

[cyrilbrd]

Most welcome.
Thanks for the feedback.