use 2 labels in x axis in charts in Excel
Q48. Is it possible to use 2 labels in X-Axis of a chart (like both Month and Date, Date and Day, Date and Shift, basically 2 different Time labels)?
For example, for the table below, in the chart X-Axis, I want both Date and Day to be displayed.
To do it in Excel, here is the answer:
a) Select the 2 columns containing the Date and Day labels as well as the column with values. Under "Insert", Click and select chart of interest (in the example below, "Line with Markers" is the option chosen).
b) Both Date and Day labels appear in the X-Axis as shown below.
Note: The columns containing the two labels need not be contiguous.