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.
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.
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.
- 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.
Read More: How to Create Graph from List of Dates in Excel (with Easy Steps)
Similar Readings
- How to Change Chart Data Range Automatically in Excel (2 Easy Ways)
- Excel Chart by Month and Year (2 Suitable Examples)
- How to Create Excel Chart Using Data Range Based on Cell Value
- Add Data Table in an Excel Chart (4 Quick Methods)
- How to Create a Scatter Chart in Excel (with Easy Steps)
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.
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.
- 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.
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.
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
- How to Add Data Points to an Existing Graph in Excel (3 Ways)
- Create Org Chart From Excel Data (With Easy Steps)
- How to Link Excel Data to PowerPoint Chart (3 Simple Methods)
- Combine Daily and Monthly Data in Excel Chart
- How to Expand Chart Data Range in Excel (5 Suitable Methods)
- Add Data to an Existing Chart in Excel (5 Easy Ways)
- How to Add Multiple Trendlines in Excel (With Quick Steps)