| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to satop chart filling in dates
I have a simple chart in which I want following dates along the x-axis
04-Nov 05-Nov 06-Nov 07-Nov 10-Nov 11-Nov 12-Nov 13-Nov 14-Nov You will notice I do not want the 8th or 9th to appear, however when I create the chart, the 8/9 automatically appear even though they are not in the data table. Any ideas on how I can get rid of pesky little creatures? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to satop chart filling in dates
Hi,
You need to force the axis to be category rather than Time series. Right click chart and pick Chart Options. Axes tab set Category axis. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "smurfdrl" wrote in message ... I have a simple chart in which I want following dates along the x-axis 04-Nov 05-Nov 06-Nov 07-Nov 10-Nov 11-Nov 12-Nov 13-Nov 14-Nov You will notice I do not want the 8th or 9th to appear, however when I create the chart, the 8/9 automatically appear even though they are not in the data table. Any ideas on how I can get rid of pesky little creatures? Thanks in advance. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to satop chart filling in dates
Thanks Andy - have a star.
"Andy Pope" wrote: Hi, You need to force the axis to be category rather than Time series. Right click chart and pick Chart Options. Axes tab set Category axis. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "smurfdrl" wrote in message ... I have a simple chart in which I want following dates along the x-axis 04-Nov 05-Nov 06-Nov 07-Nov 10-Nov 11-Nov 12-Nov 13-Nov 14-Nov You will notice I do not want the 8th or 9th to appear, however when I create the chart, the 8/9 automatically appear even though they are not in the data table. Any ideas on how I can get rid of pesky little creatures? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart filling in dates that aren't supposed to be there | Charts and Charting in Excel | |||
| Filling in specific dates in Excel | Excel Discussion (Misc queries) | |||
| Filling in missing dates | Excel Worksheet Functions | |||
| filling information from one cell and filling another. | Excel Worksheet Functions | |||
| Auto filling dates on other worksheets with data from a next payme | Excel Worksheet Functions | |||
Linear Mode
