Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2016, 11:55 PM
c991257 c991257 is offline Skipping dates with no data in chart. Windows 10 Skipping dates with no data in chart. Office 2016
Advanced Beginner
Skipping dates with no data in chart.
 
Join Date: Mar 2014
Location: Zambia
Posts: 61
c991257 is on a distinguished road
Default Skipping dates with no data in chart.


Hi.

In the attached chart I want to skip the dates where there have been no tests carried out. As far as I can tell to do that all I have to do is change the x-axis from date to text. For whatever reason that totally screws up the chart.

What am I doing wrong?

/Møller
Attached Files
File Type: xlsm 300, ARZ, Test Summary, Sample Data, 2016-08-09 -4.xlsm (160.4 KB, 15 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to identify Overlap Dates data golden618 Excel Programming 0 10-28-2015 04:34 AM
Skipping dates with no data in chart. use existing table data and not get generic excel chart data canar Word Tables 3 09-08-2015 03:36 PM
Proportionally spread dates on chart x-axis? jhoby Excel 0 06-07-2015 01:04 PM
Update a summary chart when I update a dashboard with dates cangelis Excel 6 09-24-2014 08:08 AM
Skipping dates with no data in chart. lookup dates and return corresponding data newton.rogers Excel 7 08-15-2011 11:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft