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 |