chart max & min 1

[CCNProjects]

hello all.

I would like to draw a chart with this data
month max min
Jan-06 1,717 1,567
Feb-06 1,725 1,600
Mar-06 1,725 1,600
Apr-06 1,725 1,600
May-06 1,725 1,600
Jun-06 1,693 1,557

I would like a line to go from minimum to maximum for each month.
How can I do that? Thanks in advance.

 

[mintjulep]

Use the stock chart.

Create a temporary third column of data to max Excel happy, then delete that third series after the chart is made.

 

[CCNProjects]

thanks.