I purposely changed the color of the text of the lower x-axis and the left y-axis to blue to signify that these are the axes to use for the blue series. That will assign the selected series to a secondary x-axis.īelow is an example. Click "Secondary Horizontal Axis" and pick whatever options you want. That will assign the selected series to a secondary y-axis.Ģ) With the series still selected, go to the "Chart Tools" "Layout" "Axes" selection on the ribbon.
Under "Series Options" select "Secondary Axis". Here are the steps:ġ) Right click on the series that you want to assign to the secondary axes. It requires that you assign one (or more) of the lines to a secondary y-axis and then a secondary x-axis. However, I wouldn't recommend this scheme because it is typically too confusing for others to interpret the results. There is a second way to do this where the blue series has its own x-axis and y-axis, and the red series has a different x-axis and y-axis. When I select Temp 2, the corresponding graph formula is: They are both plotted in the graph.Īs shown in the plot, the blue Temp 1 has been "selected" in the graph and the corresponding graph formula is: Temp 2 starts at 9:30:00 AM and increments by 2 minutes and 53 seconds.
Temp 1 starts at 9:00:00 AM and increments by 1 minute and 26 seconds. Below is a screenshot of an Excel sheet where two temperatures are shown. In columns or rows, using a combination of opening, high, low, and closing values, plus names or dates as labels in the right order.Use a Scatter Plot where the horizontal axis is time. In columns, placing your x values in the first column and your y values in the next column.įor bubble charts, add a third column to specify the size of the bubbles it shows, to represent the data points in the data series. In one or multiple columns or rows of data, and one column or row of labels. This chart can use one or more data series. In one column or row, and one column or row of labels. This chart uses one set of values (called a data series). Either way, this table lists the best ways to arrange your data for a given chart.Ĭolumn, bar, line, area, surface, or radar chart You also may have your own charts in mind. The charts it suggests depend on how you’ve arranged the data in your worksheet. Arrange data for chartsĮxcel can recommend charts for you. Tip: If you don't want to include specific rows or columns of data in a chart, you can simply hide them on the worksheet, or you can apply chart filters to show the data points you want after you create the chart.
0 kommentar(er)
