To hide the orange series double-press with left mouse button on the orange series to open the Format Data Series task pane. You are almost there, we need to hide the orange series and a few axes. Press with mouse on "Axes" and then "Secondary Horizontal. Press with left mouse button on "Design" tab on the ribbon, and then "Add Chart Element". Now add a secondary horizontal axis, first select the chart. The month and year values are now in the correct positions, however, the blue series is missing data points. Press with left mouse button on the next OK button. Press with left mouse button on OK button. Select the dates formatted as month and year (mmm-yy). Select Series2, press with left mouse button on the "Edit" button. Press with right mouse button on on the chart, press with left mouse button on "Select Data.". We just need to customize the chart so the right axis and values are displayed.
This made the chart look like it broke or something, however, don't panic. This will move the first series to a secondary axis allowing you to choose the axis you want to be displayed. The Format Data Series Task Pane appears, select "Secondary Axis". The chart above shows the second series in orange.ĭouble press with left mouse button on with left mouse button on the first series (blue line in above chart). Press with left mouse button on the next OK button, as well. Select the cell range containing the 0's (zeros) and press with left mouse button on the OK button. Press with left mouse button on the "Add" button, demonstrated in the image above. The "Select Data Source" dialog box appears. Now, press with right mouse button on on the chart and select "Select Data.".
#EXCEL GRAPH AXIS LABEL MONTH HOW TO#
They are not shown in the chart and I will show you how to hide them.
The next column contains 0's (zeros), these values are not needed. The dates show only month and year now, see picture to the right. Here press with left mouse button on "Custom" and type: mmm-yy To format the dates simply select the dates, press CTRL + 1 to open the Format Cells dialog box. My dates in the first dataset start in November 2017 and end in February 2018, this series also has month and year values in the same date range as my first data set. To position dates between tick marks we need an additional series, I am going to use the values displayed to the right. The chart above shows the first date in each month right below tick marks. We want month and year between tick marks, not the entire date below tick marks. This, however, is not what we are looking for. This will change how the x-axis will display the dates, it will begin with and the next tick mark is going to have the first date in the next month. Here you can easily change which date the x-axis begins with and ends with, it also allows you to specify the interval.Ĭhange Major Units from 7 to 1 and also change Days to Months. ĭouble press with left mouse button on with left mouse button on the dates right below the chart x-axis to open the Format Axis Task Pane.
The line chart x-axis shows dates with seven days interval to the next tick mark beginning with. The chart shown below is the default chart Excel creates when you insert a line chart. Then press with left mouse button on the "Insert" tab on the ribbon, press with left mouse button on the "Line" chart button and a line chart instantly appears. To insert a line chart simply select the values you want to use, I am using the values shown in the image to the right. You will need an additional series and a secondary axis to accomplish this. This tutorial demonstrates in great detail how to position month and year values between chart tick marks. The picture above shows a line chart with month and year labels between tick marks instead of date values below each tick mark. Author: Oscar Cronquist Article last updated on June 11, 2018
0 kommentar(er)
