| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I eliminate day between two dates i.e. fortnightly
I have a spreadsheet which I record fortnightly data in. When I create a
chart, the chart is picking up the days in between the fortnight dates and messing up my graph. I only want to show the actual dates ie the each fortnight in my chart |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I eliminate day between two dates i.e. fortnightly
Hi,
Sounds like you need categorical axes rather than time series. Right click chart and from the popup menu chose Chart Options. On the Axes tab set the X axis to being Category rather than Automatic. Cheers Andy Frustrated Charter wrote: I have a spreadsheet which I record fortnightly data in. When I create a chart, the chart is picking up the days in between the fortnight dates and messing up my graph. I only want to show the actual dates ie the each fortnight in my chart -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates and Intervals | Excel Worksheet Functions | |||
| formula to add dates. | Excel Worksheet Functions | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Linear Mode
