Forum Discussion
MAC OS - compress chart to eliminate zero values
John_Fletcher Not sure which solutions you found for Windows. When you work with real dates, Excel's built-in date intelligence spaces out dates on a time-line, giving you dates on the X-axis with no data points. That is true for both Windows and Mac.
If you don't want that you need to work with text labels that look like dates as shown in the attached file. And this is true also for Windows and Mac. But perhaps I haven't come across all chart related 'Windows only' features yet.
John_Fletcher Not sure which solutions you found for Windows. When you work with real dates, Excel's built-in date intelligence spaces out dates on a time-line, giving you dates on the X-axis with no data points. That is true for both Windows and Mac.
If you don't want that you need to work with text labels that look like dates as shown in the attached file. And this is true also for Windows and Mac. But perhaps I haven't come across all chart related 'Windows only' features yet.
I guess that is like
10 and 12 of July are to be skipped on chart even if they are in source table.