ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Eliminate weekends on chart (https://www.excelbanter.com/excel-discussion-misc-queries/145764-eliminate-weekends-chart.html)

looloo

Eliminate weekends on chart
 
Good morning, I am working with dates (that do not include weekends),
but when I chart the data, weekends automatically are included in the
span of time. I assume due to the time-scale option. Is there any
way that I can chart the data as is and not have the weekends
automatically entered?


Andy Pope

Eliminate weekends on chart
 
Hi,

As long as the dates you have are consecutive you can use a category
axis. Right click, choose chart options and set Axes to Category.

Cheers
Andy

looloo wrote:
Good morning, I am working with dates (that do not include weekends),
but when I chart the data, weekends automatically are included in the
span of time. I assume due to the time-scale option. Is there any
way that I can chart the data as is and not have the weekends
automatically entered?



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

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