Friday, April 19, 2013

How to Create an XY Chart


1.
Open Excel and in a new workbook, create a data spreadsheet for the XY chart to reference. Enter the months, as shown in the graphic depiction in cells 'A1' through 'M4.' (NOTE: You can create a chart similar to the one shown instead.)
2.
Select 'Insert' from the menu bar. Next, choose 'Chart.' (NOTE: You can choose the chart icon on the menu bar if it is available.)
3.
Go to the 'Standard Types' tab and select the 'XY(Scatter)' chart from the Chart Type list box.
4.
Press the 'Press and Hold to View Sample' button to preview the chart before making your final selection. When ready, click 'Next.'
5.
Verify that the data are correct and then click 'Next.'
6.
Go to the 'Titles' tab and enter a name for the chart. Enter names for 'X and Y Axis Values' if desired.
7.
Select option 'As Object In' and choose 'Sheet1.' Press 'Finish.' (NOTE: Other options include placing the chart in a different worksheet or creating a new worksheet to house the chart.)
8.
Click on the chart to activate the 'Chart' menu to modify the chart. Select 'Chart' and choose 'Chart Options.'

Blogger news