Go to Insert-Chart. Select the chart you want. On next screen, select the
series tab, and in the appropriate boxes, select the cells containing your X
and Y data, respectively. Format chart as desired.
If you set up the data properly, Excel will select the X and Y values. Put
the X values in a column, and the Y values in the adjacent column to the
right. Leave a blank cell above the column of X values, and put a label
above the column of Y values. Now run the chart wizard. You probably want an
XY chart in the first step, then in the second step, the data will have been
allocated to X and Y.
- Jon
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.