<div>
Hello,<br />
<br />
What kind of chart are you using? In an XY chart, there's not much you can do, but for other charts you can set the X axis to category instead of time, then only the data points that are in your source will appear on the X axis.<br />
<br />
cheers, teylyn
</div>


Hello,

What kind of chart are you using? In an XY chart, there's not much you can do, but for other charts you can set the X axis to category instead of time, then only the data points that are in your source will appear on the X axis.

cheers, teylyn

<div>
Using this formula works. You may have to change dd/mm/yy to mm/dd/yy<br />
<br />
=TEXT(IF(OR(WEEKDAY(A2+1)=<wbr />1,WEEKDAY(<wbr />A2+1)=7),A<wbr />2+3,A2+1),<wbr />&quot;dd/mm/yy&quot;<wbr />)
</div>


Using this formula works. You may have to change dd/mm/yy to mm/dd/yy

=TEXT(IF(OR(WEEKDAY(A2+1)=1,WEEKDAY(A2+1)=7),A2+3,A2+1),"dd/mm/yy")

Book2.xls

<div>
Your solution solved the issue for me. Spot on. Thanks alot!
</div>


Your solution solved the issue for me. Spot on. Thanks alot!

<div>
<div class="content wysiwyg-content">
I use this formula (below) in a column to create workday dates that skip Sat &amp;&nbsp;Sun. &nbsp;However, the time-series chart linked to these dates display continuous dates including the Saturdays and Sundays. &nbsp;Question: Is there a way to coax Excel into skipping the Saturday &amp;&nbsp;Sunday dates on the chart to suppress (skip) weekends? &nbsp;Or is Excel's X-axis hard wired with regard to dates with time-series charts.<br />
<br />
=IF(OR(WEEKDAY(A2+1)=1,WEE<wbr />KDAY(A2+1)<wbr />=7),A2+3,A<wbr />2+1)... where A2 contains a date
</div>
</div>


I use this formula (below) in a column to create workday dates that skip Sat & Sun.  However, the time-series chart linked to these dates display continuous dates including the Saturdays and Sundays.  Question: Is there a way to coax Excel into skipping the Saturday & Sunday dates on the chart to suppress (skip) weekends?  Or is Excel's X-axis hard wired with regard to dates with time-series charts.

=IF(OR(WEEKDAY(A2+1)=1,WEEKDAY(A2+1)=7),A2+3,A2+1)... where A2 contains a date

Time-Series Chart that skips weekend dates along the X axis... can it be done?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.