Microsoft Excel

Excel Charts - Hide months with no data | One Minute Video

Chris Menard

30 Sep 2021 — 1 min read

One of my YouTube scribers asked me, "How to Exclude Dates With No Data From Charts in Excel?" When you chart data, months with no data appear. For example, if you chart January through December and March and August do not have any data, they will show on the x-axis. You can use Format Axis and Text Axis to hide the months with no data.

Excel - hide months with no data in a chart

Excel - hide months with no data in a chart

YouTube Video

Excel Charts - Hide months with no data | Excel One Minute Quick Reference

Steps to hide months with no data

1. Select your data and make a chart using the Insert Tab and Chart group. 2. Right-click on the months in the x-axis 3. Select **Format Axis**. 4. Click **Text Axis**.

Format axis - Text Axis

Use Text Axis to hide months with no data

Read more

Chris Menard to Present “Executive Insights: Harnessing Excel for Strategic Analysis” at EA Ignite Conference

Chris Menard to Present “Executive Insights: Harnessing Excel for Strategic Analysis” at EA Ignite Conference

November 4, 2025 Microsoft MVP and productivity expert Chris Menard will be presenting a highly anticipated session titled “Executive Insights: Harnessing Excel for Strategic Analysis” at the EA Ignite Conference, held at the Renaissance Nashville Hotel. This premier event, running from November 3–5, 2025, is tailored for executive assistants

Chris Menard to Present “Mastering Microsoft 365 Copilot” at EA Ignite Conference

Chris Menard to Present “Mastering Microsoft 365 Copilot” at EA Ignite Conference

Chris Menard will present “Mastering Microsoft 365 Copilot” at EA Ignite in Nashville on Nov 3, 2025. Learn how Copilot boosts productivity in Word, Excel, PowerPoint, Outlook, and Teams during this hands-on session.

Microsoft Teams: Save Chat and Channel Messages is Back!

Microsoft Teams: Save Chat and Channel Messages is Back!

How to use the newly returned feature that lets you save Chat and Channel Messages in Teams so you can keep important conversations at your fingertips.

OneDrive Request Files: How to Use OneDrive to Collect Files Securely

OneDrive Request Files: How to Use OneDrive to Collect Files Securely

OneDrive Request Files feature allows you to collect files from people inside or outside your organization, without letting those people see anyone else’s uploads.