How to Make a Graph With a Z-Axis in Excel

how to make a correlation graph in excel

Whether you're using it for business in the office or to keep track of your finances at home, Microsoft Excel can be a great organizational tool. It can also lead to confusion until you become comfortable with it. Making a graph with a z-axis in Excel does not have to be confusing. The vertical y-axis and horizontal x-axis together depict date in two dimensions, and the z-axis takes the assimilation and presentation of data one step further into the third dimension. To use the z-axis, you simply need to know where to plug your information into Excel.

Instructions

Open Microsoft Excel and enter your data into the vertical columns. Highlight your data. Click the "Insert" tab, then click the "Chart" button under it.

Choose the graph you prefer, making sure that it is in 3-D. Click "Press and Hold to View Sample" in order to preview the chart you selected before applying it. Click "Next" once you have found the chart that works best for your purposes.

Enter

your data range by highlighting the appropriate columns of data and then clicking the button beside the field your selected information appears in. Click the "Series" tab to edit or modify your data series and their names.

Click "Next," then click the "Titles" tab of the next window. Type in a title for your graph and titles for the x, y, and z axes.

Click the "Axes" tab for options to make your axes' information visible or invisible. Click the "Gridlines" tab to make gridlines visible or invisible. Click the "Legend" tab to make your legends visible or invisible. You can also use this tab to determine legend placement.

Click "Data Labels" to choose which pieces of series information and titles you want to show out of all you have entered.

Click "Data Table" to view all of the series data you have entered in your graph in table form.

Click "Next." Select your chart location and placement in the final window that pops up. Click "Finish."

Source: ehow.com

Category: Forex

Similar articles: