ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Dates on Charts (https://www.excelbanter.com/excel-discussion-misc-queries/99070-dates-charts.html)

corona91719

Dates on Charts
 

I am making some charts with a daily rate. How do I remove the
non-working days? Example is that the line graph shows Saturday and
Sunday. I don't want that. Just working days or days with data.

Thanks


--
corona91719
------------------------------------------------------------------------
corona91719's Profile: http://www.excelforum.com/member.php...o&userid=32527
View this thread: http://www.excelforum.com/showthread...hreadid=561083


Franz Verga

Dates on Charts
 
corona91719 wrote:
I am making some charts with a daily rate. How do I remove the
non-working days? Example is that the line graph shows Saturday and
Sunday. I don't want that. Just working days or days with data.

Thanks


Try to insert as data for Saturday and Sunday #N/A: the chart should skip
this days...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy




All times are GMT +1. The time now is 03:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com