Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xy-chart with dates on x-axis
Hello,
XL 2002 I have the following data for an xy-chart. I would like to have months as labels on the x-axis (like 1/05, 2/05 etc.) where the end of the month should be labeled. series1(cost) x y 01.01.05 2 01.02.05 5 01.03.05 8 01.04.05 14 series2(revenue) x y 15.01.05 4 10.03.05 10 series3(end of quarter) x y 28.02.05 0 28.02.05 15 The problem is that there's no possibility to define dates for the x-axis. The only thing I can do is using a number format like "01".MM.YY or MM.YY. However, I get labels like this: 09/04 10/04 10/04 12/04 12/04 01/05 03/05 04/05 etc. The intervall can be set eg. to 30, 31 or 30.4166667 (=365/12), but still the labes do not work correctly. With some method I get correct labels, however, the data does not fit, eg. 01.03.05 is between 02/05 and 03/05 and not very close to 02/05. I think, I have to use xy-charts as other charts have problems with the different periods and number of points esp. of series1 and series2 (I do not need series 3 if I get correct lables on the x-axis). regards arno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
bar chart with dates on the x-axis | Charts and Charting in Excel | |||
dates on scatter chart axis | Charts and Charting in Excel | |||
Chart Dates on X Axis | Excel Discussion (Misc queries) | |||
Help with Dates on Y Axis of a chart | Charts and Charting in Excel | |||
Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) |