View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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?