Hey!!
I’ve been having some troubles with Excel 2003 (SP2) chart.
I’ve to do a chart which the x axis is date type data and in which the same date has several values. Even the date table has some gaps: 1st cell: 01-01-2006; 2nd:02-01-2006; 3rd: 13-01-2006; 4th: 14-01-2006, etc
Now what is happening is if I just insert data on the Y axis and nothing on the X axis, I’ve got a completely different chart than if I add also the dates on the X axis.
I need the chart result as the same without the dates on, but I do need to put them there.
I’m using a standard chart type – the line.
This is a sample of the data I’m using:
75,6 01-01-2007
0 01-01-2007
0 02-01-2007
9,4 03-01-2007
102 03-01-2007
37,8 03-01-2007
0 15-01-2007
(the bold number represents a different row from the date.)
Usually which date has a correspondence of at least 30 values, and the average total cells are around 20000.
Can you u help me up?. I’ve been fight this for a long time… I’m considering going for VBA programming
Bookmarks