| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Axis
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Axis
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Axis
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Axis
Another way is to convert your dates to text: =TEXT(A1,"dd/mm/yy")
-- Kind regards, Niek Otten Microsoft MVP - Excel "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? | | | |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Axis
Thank you that's the one! Perfect.
"Niek Otten" wrote: Another way is to convert your dates to text: =TEXT(A1,"dd/mm/yy") -- Kind regards, Niek Otten Microsoft MVP - Excel "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? | | | |
|
#6
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 | |||
Linear Mode
