Excel Xy Diagramm. Application cel tools currently the easiest way to take xyz data and produce a 3d graph with rotation and zooming is with the excel add in cel tools. Click the chart type dropdown in the area series row and select area or stacked area doesn t matter which in this case since there s only one area series.
Making an xy graph in excel is a straightforward process thanks to built in graph making features for both line and scatter graphs. Right click on the area series which is still of type xy and choose change series chart type. A line graph is usually better for sequential data.
In excel 2013 the change chart type dialog appears.
Which axis is to remain the primary axis is complete up to the user of the chart. It is the only program available that exports all converted data into excel s native formats. Figure 1 how to plot data points in excel. Step 1 arrange the data in columns or rows on the worksheet.
