Use 2 labels in x axis in charts in Excel
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.