| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dates in chart
I have a chart that has data for Monday-Friday only of each week for 12
weeks. The dates are based upon a formula, so alternate every week showing a rolling 12 week chart. Unfortunately, the chart is showing 5 days with 2 days for the weekend being blank as there is never data at the weekends and so far attempts to rid the weekends, which are not in the original data at all, have proved futile. Can anyone suggest how to rid Saturday and Sunday from the chart? All help appreciated. Ellie |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dates in chart
Hi,
You need to set the axis to be category rather than date. Right click chart and pick Chart Options. On the Axis tab check the Category option for the axis. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Ellie" wrote in message ... I have a chart that has data for Monday-Friday only of each week for 12 weeks. The dates are based upon a formula, so alternate every week showing a rolling 12 week chart. Unfortunately, the chart is showing 5 days with 2 days for the weekend being blank as there is never data at the weekends and so far attempts to rid the weekends, which are not in the original data at all, have proved futile. Can anyone suggest how to rid Saturday and Sunday from the chart? All help appreciated. Ellie |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dates in chart
Thank you so much, Andy. Works great.
Ellie "Andy Pope" wrote: Hi, You need to set the axis to be category rather than date. Right click chart and pick Chart Options. On the Axis tab check the Category option for the axis. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Ellie" wrote in message ... I have a chart that has data for Monday-Friday only of each week for 12 weeks. The dates are based upon a formula, so alternate every week showing a rolling 12 week chart. Unfortunately, the chart is showing 5 days with 2 days for the weekend being blank as there is never data at the weekends and so far attempts to rid the weekends, which are not in the original data at all, have proved futile. Can anyone suggest how to rid Saturday and Sunday from the chart? All help appreciated. Ellie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates not formatting on Chart | Charts and Charting in Excel | |||
| chart dates | Charts and Charting in Excel | |||
| chart with dates on the x-axe | Charts and Charting in Excel | |||
| How do I get the dates on an excel chart to stay as dates instead. | Charts and Charting in Excel | |||
| Help with Dates on Y Axis of a chart | Charts and Charting in Excel | |||
Linear Mode
