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.

excel use 2 labels in x axis in charts

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).

excel excel use 2 labels in x axis in charts

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.

excel excel excel use 2 labels in x axis in charts

 

You can find similar Excel Questions and Answer hereunder

1) How can I enter information in multiple cells simultaneously?

2) How can I have text autocomplete by typing in a short code for the text?

3) How do I change the rating numbers to rating labels?

4) How can I enter multiple lines of data in a cell?

5) How can I enter multiple lines of data in a cell?

6) Is there a way to easily shade alternate rows in a data range for improving readability?

7) Is there a way I can easily identify the duplicate values in a dataset?

8) How can I dynamically add series to an existing chart using VBA?

9) How can I remove hyperlinks from a range of cells?

10) How can I use SUMPRODUCT to summarize my raw data?

11) How can I find the number of working days between 2 dates using VBA?

12) I want to automatically run a procedure whenever I close my WorkBook so that it is in a known state - how can I achieve that?

13) I am not able to use VLOOKUP as the lookup value column is to the right of the column that has the information I need. Is there an alternative option?

14) How can I get row count of filtered data?

15) How do I use Find to determine last occurrence of a string in a WorkSheet range using VBA?