How to Change Date Range in Excel Chart (3 Quick Ways)

If you are looking for a way to change the date range in an Excel chart easily and quickly then you have come to the right place. The objective of this article is to explain how to change date range in an Excel chart.

How to Change Date Range in Excel Chart: 3 Quick Ways

Here, I have taken the following dataset for this article. This dataset contains the Date and Sales columns. And these data are represented in a Column Chart. Now, I will use this dataset to explain how to change date range in Excel chart in 3 quick ways.

1. Use Format Axis Feature to Change Date Range in Excel Chart

In this method, I will show you how you can use the Format Axis feature to change date range in Excel chart. Let’s see the steps.

Steps:

Firstly, right-click on the axis that contains Dates.
Secondly, select Format Axis.

Thirdly, the Format Axis task pane will appear on the right side of the screen.
Write the start date of the date range in the Minimum section.
Then, write the end date of the date range in the Maximum section.

After that, you will see that the date range in the Excel chart is changed according to your preference.

Now, you can get the chart as it was before changing the date range.
To do so, simply click on the Reset button.

Here, you can see that I have got the chart as it was before changing the date range.

2. Add Filter to Change Date Range in Excel Chart

You can also add a filter to the range from which you made the Excel chart to change the date range. Let’s see how you can do it.

Steps:

In the beginning, select the cell where you want to add the filter. Here, I want to add the filter to the Date column.
Then, go to the Data tab.
Next, select Filter.

After that, you will see that the folder is added to the Date column.
Click on the Filter button.
Then, select Date Filters from the drop-down menu.
Next, select the option you want to change the date range. Here, I selected This Week.

Finally, you can see that I have changed the date range of the chart to this week and it is showing data from this week.

Now, I will change the date range of the chart as it was before.
Select the Filter button.
Then, select Clear Filter From “Date”.

In the following image, you can see that the filter is removed from the date range in Excel.

3. Employ Pivot Chart Timeline to Change Date Range in Excel

Here, I will explain how you can employ Pivot Chart Timeline to change the date range in Excel. I will show you the procedure in 2 easy steps. Let’s explore the step-by-step procedures.

Step-01: Create Pivot Chart in Excel

In this step, I will show you how you can insert a Pivot Chart in Excel. Let me show you the steps.

Firstly, select the range with which you want to make the Pivot Chart. Here, I selected the cell range B4:C14.
Secondly, go to the Insert tab from the Ribbon.
Thirdly, select PivotChart.

After that, the Create PivotChart dialog box will appear.
Select Existing Workbook.
Then, select the Location where you want the Pivot table.
Next, select OK.

Afterward, the PivotChart Fields task pane will appear on the right side of the screen.
Select and drag the fields you want in the Axis area. Here, I selected the Date field and dragged it into the Axis area.
Then, select the drag the fields you want in the Values area. Here, I selected the Sales field and dragged it into the Values area.

Finally, you will see that you have inserted the Pivot Chart into your Excel sheet.

Step-02: Add Timeline to Pivot Chart

Now, I will add a timeline to the Pivot Chart. Let me show you how to do that.

To begin with, select the Pivot Chart.

After that, go to the PivotChart Analyze tab.
Then, select Insert Timeline.

Afterward, the Insert Timelines dialog box will appear.
Check the Date option.
Then, select OK.

Next, the Timeline will appear.
Select the month in which you want to see the data. Here, I selected OCT so that I can see the Sales in October.

Finally, you can see that I have changed the date range in the chart according to my need.

You can also see data from Days, Years, or Quarters.
To do that, click on the marked button and then select the option as per your need.

Now, to clear the filter Click on the marked button in the following picture.

Here, you can see that I have removed the filter successfully.

Practice Section

Here, I have provided a practice sheet for you to practice.

Download Practice Workbook

You can download the practice workbook from here.

Changing Date Range.xlsx

Conclusion

To conclude, I tried to cover how to change date range in an Excel chart in this article. Here, I explained 3 quick ways of doing it. I hope this article was helpful to you. If you have any questions, feel free to let me know in the comment section below.

<< Go Back to Edit Chart Data | Excel Chart Data | Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!