| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Axis
Hi,
As long as the chart type is not xy-scatter you would select the x axis, right click and Format Axis. On the Axis Options page is the Axis Type: Text Axis. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Skip4t" wrote in message ... Thanks, forgot to mention I am in Excel 2007. I've tried everything and can't get it right! "Bernard Liengme" wrote: Excel is being a little too helpful. Right click the chart; from shortcut menu select Chart Options Open Axes tab and select for x-axis Category rather than Automatic or Time-Scale best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Skip4t" wrote in message ... I have 5 dates in a series of data: - 31/12/07 31/01/08 28/02/08 31/03/08 30/04/08 when I create the chart these dates appear as: - 01/12/07 01/01/08 01/02/08 01/03/08 01/04/08 How can I get the dates on the axis to match the dates in the data series? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I force a secondary horizontal axis to act as a date axis? | Charts and Charting in Excel | |||
| X axis date - display beyond latest date. | Charts and Charting in Excel | |||
| Date Axis Must be on Date Basis | Charts and Charting in Excel | |||
| date axis | Charts and Charting in Excel | |||
| how to draw a chart using x,y axis not the date with x-axis? | Excel Worksheet Functions | |||
Hybrid Mode
