Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
work with conventional dates for axis scale
How do I scale a time-scale axis using the conventional date format instead
of a date in the mysterious long string of numbers that randomly shows up for the dates? Why does this change from chart to chart (sometimes conventional date formatting, sometimes the string of numbers) and how do I change it or prevent it from being that way in the first place? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
work with conventional dates for axis scale
In EXCEL 2007 take the following action (as a simple example that gives you
what you want):- 1. In cells G 13 to G 22 inclusive format the cells as follows:- - highlight the cells / right click / Format Cells / Number tab (set Category: to Date and Type: to * 14 March 2001) / click OK. You have now formatted the said range of cells as date. 2. In cells H 13 to H 22 inclusive enter the numbers 1 to 10. 3. Highlight the range of cells:- G 13 to H 22 inclusive 4. Insert / Charts group / Column / in 2-D Column click on Clustered Column 5. You should now get a chart with date the way that you want them on the horizontal axis. If my comments have helped please hit Yes. Thanks. "gkr" wrote: How do I scale a time-scale axis using the conventional date format instead of a date in the mysterious long string of numbers that randomly shows up for the dates? Why does this change from chart to chart (sometimes conventional date formatting, sometimes the string of numbers) and how do I change it or prevent it from being that way in the first place? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
work with conventional dates for axis scale
In EXCEL 2007 there is also a Help topic called:-
Display dates on a category axis Do a search on the above for a fuller explanation. If my comments have helped please hit Yes. Thanks. "gkr" wrote: How do I scale a time-scale axis using the conventional date format instead of a date in the mysterious long string of numbers that randomly shows up for the dates? Why does this change from chart to chart (sometimes conventional date formatting, sometimes the string of numbers) and how do I change it or prevent it from being that way in the first place? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Scale X axis doesn't work with "" values in cell | Charts and Charting in Excel | |||
How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit | Charts and Charting in Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel |