Plotting Grapgh in Excel

[ajit.nayak87]

nrel25mar.xls

Dear all,
I have attached Excel sheet as above. I wanted to plot graph time vs pic-zenith,pic-azimuth,pic-elevation .
I tried to plot graph but value of point in excel sheet is differ from table value. For single grapgh no problem,When all put together leading some problem.

Can some one suggest what kind of char can plotted above reading values

[Andy Pope]

You did not include the chart so we can not tell what you did or what was wrong.

[ajit.nayak87]

nrel25mar.xlslet me know step process of plotting graph. I have added graph. Check the value relvant yo tables

[Andy Pope]

for some reason you have chosen the Stacked Line chart, which plots each series on top of the previous ones values.

Change chart type to clustered. If your time values are not equally spaced then you should really use the xy-scatter.