Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
graphing dates
I'm trying to graph these dates;
9/1 9/5 9/6 But when I do this, 9/2, 9/3, and 9/4 are showing up on the chart. I don't have data for these dates so I don't want to include them. Why is it automatically entering?? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
graphing dates
Hi,
The chart wizard is trying to be helpful by assuming you want a time series axis for your dates. If you don't and you actually want just categories then right click the chart and pick chart options... On the axis tab set the scale to be category rather than automatic. Cheers Andy dw9050 wrote: I'm trying to graph these dates; 9/1 9/5 9/6 But when I do this, 9/2, 9/3, and 9/4 are showing up on the chart. I don't have data for these dates so I don't want to include them. Why is it automatically entering?? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
graphing dates
Thanks Andy!!
"Andy Pope" wrote: Hi, The chart wizard is trying to be helpful by assuming you want a time series axis for your dates. If you don't and you actually want just categories then right click the chart and pick chart options... On the axis tab set the scale to be category rather than automatic. Cheers Andy dw9050 wrote: I'm trying to graph these dates; 9/1 9/5 9/6 But when I do this, 9/2, 9/3, and 9/4 are showing up on the chart. I don't have data for these dates so I don't want to include them. Why is it automatically entering?? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graphing or charting dates | Charts and Charting in Excel | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Dates and Recomended Graphing Programs to work with excel? | Charts and Charting in Excel | |||
Thorny problem graphing XAxis dates | Charts and Charting in Excel | |||
Graphing inconsistent dates and data | Charts and Charting in Excel |