Excel Step-by-Step
Excel Step-by-Step
Import data into a new workbook (or open an existing spreadsheet)
Choose the chart wizard from the toolbar.
Choose the chart type.
The most common chart type you will use will be a scatter plot (XY). Note: The plot is most easily interpreted if you choose the scatter plot that DOES NOT connect the data points with a line.
Sometimes, a line plot is needed (if you need text labels on the X axis instead of numbers).
Choose the subtype.
THINK about how you want the data to look. Do you need a line to collect all the points? Especially, if you’re going to plot a trend-line over them….
Are you plotting one set of data or overlaying several? If you need to overlay choose the Series tab.
Click “add”, then you can name your series. Click in the “x values” box and then highlight the x values in your spreadsheet. Repeat for the y values using the “y values” box.
Note: if you want to overlay a new data set onto an existing plot, select the chart by clicking in it. Pull down the “Chart” menu and select “Source Data” This will bring you to the “series” window an you can add additional data sets as previously described.
Change your chart options how you see fit. Name your chart and label your x and y axes. Decide if you want gridlines, where to place your legend, and if you want data labels.
Decide if you want your chart next to your data in the spreadsheet, or if you want it on a new sheet.
To format any of the chart features (i.e. plot background color, changing axes to logarithmic scale, etc.) you can usually double click on the feature. You can also format by placing your cursor within the chart area and right clicking and then choosing the feature you want to change.
Use Help if needed.
To print just the chart, click on it so that the chart is outlined and then press the print key in the toolbar. To print with the spreadsheet, unhighlight the chart and then go to print preview to make sure that everything is formatted correctly and will fit in the area that you want it to.
REE Chart
Open data.
Choose the chart wizard from the toolbar.
Choose the chart type.
Choose the line plot. This will allow you to have text labels on your x-axis.
Choose the subtype.
THINK about how you want the data to look. Do you need a line to collect all the points? Especially, if you’re going to plot a trend-line over them….
Choose the series tab.
Click “add”, then you can name your series. Click in the “values” box and then highlight the values in your spreadsheet. In order to get the REE labels on the x-axis click in the “x-axis (category) labels” box and highlight the REE names. Make sure to check in your final plot that the labels are correct.
Change your chart options how you see fit. Name your chart and label your x and y axes. Decide if you want gridlines, where to place your legend, and if you want data labels.
Decide if you want your chart next to your data in the spreadsheet, or if you want it on a new sheet.
To format any of the chart features (i.e. plot background color, changing axes to logarithmic scale, etc.) you can usually double click on the feature. You can also format by placing your cursor within the chart area and right clicking and then choosing the feature you want to change.
Use Help if needed.
To print just the chart, click on it so that the chart is outlined and then press the print key in the toolbar. To print with the spreadsheet, unhighlight the chart and then go to print preview to make sure that everything is formatted correctly and will fit in the area that you want it to.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- pda stats manual
- activity 8 making a line chart
- attachment 3 comments about equations
- bar graphs with benchmark line
- correlation university of houston
- types of graphs
- ap biology graphing assignment science site
- plot diagram template
- template for developing sewer collection system preventive
- plot graphic organizer
Related searches
- photosynthesis process step by step easy
- step by step essay example
- step by step writing template
- step by step business plan template
- step by step cellular respiration
- step by step starting business
- photosynthesis step by step biology
- step by step protein synthesis
- step by step business plan
- step by step watercolor lessons
- step by step research paper guide
- step by step mortgage guide