Why are the dates on my Excel graph wrong?

Make sure that the cells you are referencing (as axis labels) are “text” category and not “date” or another category. THEN, in the horizontal axes additional formatting dialogue, click “axes options”, under “axis type” make sure “Text axis” is checked. This should help.

How do I change axis options in Excel?

Click anywhere in the chart for which you want to display or hide axes. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Layout tab, in the Axes group, click Axes. Click the type of axis that you want to display or hide, and then click the options that you want.

How do I change axis labels in Excel?

Right-click the category labels you want to change, and click Select Data.

In the Horizontal (Category) Axis Labels box, click Edit.
In the Axis label range box, enter the labels you want to use, separated by commas.

Can’t change axis bounds Excel?

Figure 1.

Right-click on the axis whose scale you want to change. Excel displays a Context menu for the axis.
Choose Format Axis from the Context menu.
Make sure Axis Options area is expanded.
Adjust the Bounds and Units settings, as desired.
Close the Format Axis task pane.

Where is Axis option in Excel?

Click the chart, and then click the Chart Layout tab. Under Axes, click Axes > Vertical Axis > Axis Options.

How do you switch axis on Excel?

How to switch axes in excel

Click on the chart and choose the Design tab,
Go to Data >> Switch Row / Column.
Now, the X-axis switched with the Y-axis without the need for transposing data.

How do I change the axis date in Excel?

Display or change dates on a category axis

In the chart, right-click the category axis, and then click Format Axis.
In the Format Axis pane, select the Axis Options tab.
Expand Axis Options, and then under Axis Type, make sure Date axis is selected.
Under Units, next to Base, select Days, Months, or Years. Notes:

How do you switch columns in Excel?

Left click on the edge of the column and hold the Shift key. Drag the column to the one you want to swap it with. You should see a ‘|’ line indicating where the next column will be inserted. Release the mouse and the Shift key.

How do you change the axis on Excel?

Why can’t I switch rows and columns in Excel?

The way to fix this is to switch the rows and the columns. The problem is that the Switch Row/Column button on the Chart Tools Design tab is grayed out. Apparently, you have to edit and select the data to switch the rows and columns. Click the Select Data button.

How do you change date on x axis in Excel?

To display the date and time correctly, you only need to change an option in the Format Axis dialog. 1. Right click at the X axis in the chart, and select Format Axis from the context menu. See screenshot: 2. Then in the Format Axis pane or Format Axis dialog, under Axis Options tab, check Text axis option in the Axis Type section.

How to change dates on a category axis?

1 In the chart, right-click the category axis, and then click Format Axis. 2 In the Format Axis pane, select the Axis Options tab. 3 Expand Axis Options, and then under Axis Type, make sure Date axis is selected. 4 Under Units, next to Base, select Days, Months, or Years. Notes: You cannot have a date axis if the dates in your chart… More

How do I change the date and time on a chart?

How do you change the axis of a chart?

Right click at the X axis in the chart, and select Format Axis from the context menu. See screenshot: 2. Then in the Format Axis pane or Format Axis dialog, under Axis Options tab, check Text axis option in the Axis Type section. See screenshot: