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.


Download Practice Workbook

You can download the practice workbook from here.


3 Quick Ways to Change Date Range in Excel Chart

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 (with Easy Steps)


Similar Readings


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 Import and Use Data into Power Pivot 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 (With Easy Steps)


Practice Section

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

Practice Sheet for How to Change Date Range in Excel Chart


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. For more articles visit ExcelDemy. If you have any questions, feel free to let me know in the comment section below.


Related Articles

Mashhura Jahan

Mashhura Jahan

Hey! Welcome to my profile. Currently, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

We will be happy to hear your thoughts

Leave a reply

5 Excel Tips
You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo