Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Line Chart with dates in 5 day working week only
Hi,
Trying to format a chart so that only the 5 working days of the week are displayed on the x axis. The source data only has the five days (e.g. 05/09/2005 down to 09/09/2005 and then on to 12/09/2005 down to 16/09/2005 etc etc) So I have missed out the weekend dates. When I create the line chart however, the weekend dates appear automatically and just show no point on the chart, therefore there is a longer line between Fridays and Mondays!! Hope this makes sense. Does anyone have any ideas on how to change this? I have tried looking at Tools-options-chart and cannot seem to turn this feature off. Thanks |
#2
|
|||
|
|||
Hi,
Try right clicking chart and chose Chart Options. On the axes tab change the chart to category instead of automatic or time series. Cheers Andy Danger wrote: Hi, Trying to format a chart so that only the 5 working days of the week are displayed on the x axis. The source data only has the five days (e.g. 05/09/2005 down to 09/09/2005 and then on to 12/09/2005 down to 16/09/2005 etc etc) So I have missed out the weekend dates. When I create the line chart however, the weekend dates appear automatically and just show no point on the chart, therefore there is a longer line between Fridays and Mondays!! Hope this makes sense. Does anyone have any ideas on how to change this? I have tried looking at Tools-options-chart and cannot seem to turn this feature off. Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
That's got it! Thanks Andy.
"Andy Pope" wrote: Hi, Try right clicking chart and chose Chart Options. On the axes tab change the chart to category instead of automatic or time series. Cheers Andy Danger wrote: Hi, Trying to format a chart so that only the 5 working days of the week are displayed on the x axis. The source data only has the five days (e.g. 05/09/2005 down to 09/09/2005 and then on to 12/09/2005 down to 16/09/2005 etc etc) So I have missed out the weekend dates. When I create the line chart however, the weekend dates appear automatically and just show no point on the chart, therefore there is a longer line between Fridays and Mondays!! Hope this makes sense. Does anyone have any ideas on how to change this? I have tried looking at Tools-options-chart and cannot seem to turn this feature off. Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination of stock chart and line chart | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Line chart in Excel - trendline incomplete | Charts and Charting in Excel | |||
how do I draw a line in a chart at a specific location | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |