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? |
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