| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
chart only weekdays when data set includes weekends?
I've got a simple table of data:
A B date1 val1 date2 val2 .... dateN valN I have several hundred data points, including weekends, but I would only like to chart the weekdays. Is there a straightforward way to do this? Regards, George Coulouris |
|
#2
|
|||
|
|||
|
Jon Peltier has instructions for conditional charts that you could adapt
to your workbook: http://www.peltiertech.com/Excel/Cha...html#CondChart For example, with dates in column A, use the Weekday function to return dates for Monday to Friday. =IF(WEEKDAY($A2,2)=6,NA(),A2) wrote: I've got a simple table of data: A B date1 val1 date2 val2 ... dateN valN I have several hundred data points, including weekends, but I would only like to chart the weekdays. Is there a straightforward way to do this? Regards, George Coulouris -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
That did the job!
Thanks, George |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
| Chart - Data Tables | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
