Plot high and lows of data.

[wowzers]

I have a 46000 rows of data. I want to make a chart, but only want to plot the highest and lowest data points in the data set (plot a zig zag of the high and low of a specified time interval). How do I get Excel to automatically find and plot only the highest and lowest data points?

 

[swst]

Use the functions "LARGE" and "SMALL"
to graph i usually use the "stocks" graph

Note you might need to do an "AVERAGE" function aswell for the graph but can delete series name on the chart

S