| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove weekends from a stock chart | Charts and Charting in Excel | |||
| How to remove weekends from chart in Excel 2007 ? | Charts and Charting in Excel | |||
| Chart with colored weekends | Charts and Charting in Excel | |||
| chart only weekdays when data set includes weekends? | Charts and Charting in Excel | |||
| How do I eliminate non-used dates (weekends) from a chart? | Charts and Charting in Excel | |||
Linear Mode
