How do I display dates on the Horizontal axis of a chart

Question

I am following this steps to display date on the horizontal axis of a chart:

1. Click the chart, and then click the Chart Design tab.
2. Click Add Chart Element, click Axes, and then click More Axis Options. The Format Axis pane appears.
3. For the axis that you want to change, make sure that the axis labels show.
4. Under Axis Type, select Date axis.
5. Under Units, in the Base drop-down list box, select Days, Months, or Years.

When I get to step 4, I can not find "Date axis".

Answer 1

Hi Jim,

Right click on the horizontal axis and choose Format Axis

In the Format Axis pane, click the disclosure triangle for Number, and then change the Category to Date and choose a Type.

Answer 2

As I had pointed in my first reply - The kind of graph you are showing seems to be made on the basis of one column of data, that is why it is showing 1, 2, 3..

Your chart is made on only one column i.e. B. You needed to make chart on columns A and B. Select A1:B10 and then make the chart.

Answer 3

I need to have a look on your workbook to provide you the solution specific to your problem.

Request you to please prepare and upload a sample / dummy file sans confidential / sensitive data to Onedrive and share the link? It will help me to give prompt and right solution.

You can upload from Onedrive application on your computer.

If you don't have this application,

1. Login to https://onedrive.live.com/ utilizing the same Login ID and Password which you have used on this forum. (or use the installed Onedrive on your computer)
2. Click Upload in the top OR drag and drop the file here.
3. After uploading, right click the file and choose share.
4. Optional but recommended - Uncheck the Allow Editing
5. Click Get a Link.
6. Copy the link and paste the link here.

Answer 4

Many thanks.  Here is the link:

https://1drv.ms/x/s!AmG5V3\_zNlApeLDQS4cs1VwkAlM