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

Get FREE Advanced Excel Exercises with Solutions!

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.

How to Change Date Range in Excel Chart


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.

Use Format Axis Feature to Change Date Range in Excel Chart

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

Seeting End Date and Start Date to Change Date Range in Excel Chart

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

Resetting to Change Date Range as before in Excel Chart

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

Read More: How to Show Only Dates with Data in Excel Chart


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.

Add Filter to Change Date Range in Excel Chart

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

Selecting Date Filters to Change Date Range in Excel Chart

  • 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”.

Using Clear Filter from "Date" to Change Date Range in Excel Chart as Before

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

Read More: How to Create Graph from List of Dates 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.

Employ Pivot Chart Timeline to Change Date Range in Excel

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

Create Pivot Chart in Excel to Change Date Range

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

Read More: How to Change Chart Data Range in Excel


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.

Add Timeline to 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.

Insert Timelines Dialog box to Change Date Range in Excel Chart

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

Read More: How to Plot Time over Multiple Days in Excel


Practice Section

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

Practice Sheet for How to Change Date Range in Excel Chart


Download Practice Workbook

You can download the practice workbook from here.


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.


Related Articles


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mashhura Jahan
Mashhura Jahan

Mashhura Jahan, BSc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology, invested 1.5 years at ExcelDemy. In roles like Excel & VBA Content Developer, Excel Charts, and Dashboard course trainer, she wrote 90+ articles. She was previously part of the forum support team and a junior software analyst on the Excel Add-in project. With interests spanning Excel, VBA, Power Query, Python, Data Science, and Software Development, Mashhura brings a diverse skill set to her... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo