change the x axis values in exel 2011 for mac

#CHANGE THE X AXIS VALUES IN EXEL 2011 FOR MAC HOW TO#
#CHANGE THE X AXIS VALUES IN EXEL 2011 FOR MAC MANUAL#
#CHANGE THE X AXIS VALUES IN EXEL 2011 FOR MAC SERIES#
#CHANGE THE X AXIS VALUES IN EXEL 2011 FOR MAC DOWNLOAD#

#CHANGE THE X AXIS VALUES IN EXEL 2011 FOR MAC HOW TO#

How to Make Dates Show Up on the Horizontal Axis in a Chart in Excel, After you create a chart based on your worksheet data, Excel enables you to edit For example, entering dates along the x-axis gives your clients a view of your Even just one duplicate record in an Excel worksheet can be costly in terms of For example, entering dates along the x-axis gives your clients a view of your sales over time. Under Units, next to Base, select Days, Months, or Years. Expand Axis Options, and then under Axis Type, make sure Date axis is selected. In the Format Axis pane, select the Axis Options tab. I want to display the given In the chart, right-click the category axis, and then click Format Axis. My dates are unevenly distributed, diff between successive dates are 5 to 7 days. Karraj.Ĭharting, how to make x axis display the desired dates only, I have dates in x axis and values in y axis. I want to display the given dates and the associated data.

I have dates in x axis and values in y axis. How to make x axis display the desired dates onlyĭisplay or change dates on a category axis, is selected.

#CHANGE THE X AXIS VALUES IN EXEL 2011 FOR MAC SERIES#

If I select just 1 set of values (1 column of X values and 1 columns of Y values with a series name on top) it will plot the Y values vs the position (1-35 rather than the actual X values) and when I hover over them it will say something like: Series 'Name' Point 'X value' (Y value, position) where X value is the number I actually want on the X axis, but position ) the plot is displayed with x-axis values as 1,2,3 but not as the data specified. When I want to add a new series with similar x-axis data (0.0, 0.4, 0.9. I have an excel scatter plot with 5 different data series on single chart. When I insert a column chart, the xĮxcel scatter plot x axis displays only sequential numbers but not real data selected for x axis. The next column is 'amount' which has dollar amount values.

In this example, doing so will add “featured on ” to our line.Excel chart x axis showing sequential numbers, not actual value In addition, you can change the scale of the axis to expand or contract the vertical line as you wish.Īnd last but not least, you can access the “Format Data Series” dialog box for the single vertical line data point (as was discussed above) and add the y-axis column label to your line by selecting the “Data Labels” tab and checking “Series name” under the Data Labels section. Choose the “Patterns” tab and you can choose “None” for all the line and tick mark labels to hide the axis on the chart. In addition, you can hide the secondary axis by clicking on it once to select it, then right clicking the secondary axis and select “Format Axis…”. So to improve the appearance of your chart, you can format the vertical bar by clicking on it once to select it, then right clicking on the bar and selecting “Format Error Bars…” and click the “Patterns” tab to change the look of the error bar as you wish. You’re basically done at this point and although this technique for adding a vertical line is useful, it’s not easy on the eyes. It doesn’t matter what you name your y-axis data ( you will see why “featured on ” is being used in a moment) or what value you use as long as it is in the neighborhood of the data that has been plotted. For this example, the date when was featured on is being used as the vertical line data. Be sure to follow the same data structure that you used for your original data. In a separate area on your worksheet, add the info for the vertical line data. Step 2: Add the vertical line data to your chart… Be sure to follow all the Chart Wizard steps and choose the “as object in” option to place the chart in your worksheet ( we can change the location of the chart later).

#CHANGE THE X AXIS VALUES IN EXEL 2011 FOR MAC DOWNLOAD#

If you want to follow the example in this tutorial, you can download the Excel spreadsheet * HERE*. Using the Chart Wizard, create an XY (Scatter) chart with time on the x-axis and your numeric data on the y-axis. Step 1: Create an XY (Scatter) chart…įor this example, feed subscribers for the month of May is being used. Thankfully, there’s a “hack” that can eliminate the hassle of drawing vertical lines while allowing you to instantly change their position with a few mouse clicks.

#CHANGE THE X AXIS VALUES IN EXEL 2011 FOR MAC MANUAL#

The issue is that these lines aren’t bound to the x-axis, so any change to the chart is usually accompanied by manual line repositioning. Normally, one turns to the line tool in Excel to manually draw vertical lines on a chart.

Change the x axis values in exel 2011 for mac