Gentlemen,

I have an existing Excel file (Office 2003) that we opened in Excel 2007. No
compatibility problem were found.
The date page (Salesdata) consist of two columns
A4 to A186 (Date format from April1993 until July2008 ) and B4 to B186
(Sales/normal value data April1993 until July 2008)
Next there are 12 charts (January until December)
Each chart contains the month value of each year.
Example, The March chart contains the data from March 1994 until April 2007.
Problem/Bug: When we try to add the data of March 2008 (A183:B183) to the
chart March it doesn't work ????
We made a copy of (A183:B183), then open the March chart then we did a Paste
Special (new point to the chart) and the data is not added the chart.
If you look then to the formule string you will see that only the A183 is
added and the B value not ???
If we use a normal Paste the data is added right from column March 93 and is
created as a new series.

Via Microsoft support Netherland we got the work around ??? to create a new
chart and add all date by using Select data then Add new data (A value B
value) The result is that you get the 12 month values in the chart but then
as 12 individual series , the big issue is now that you can't create any
trend line on the chart because the trendline works only on one serie.
This problem is a major drawback comparing with to way it pas possible in
Excel 2003

In short we cann't add more date (in the same serie) to and exiting chart.
Microsoft say's that it has to do with the internal data base, the max new
date entries is limitted to 15. In my case 15 months. Why ???

Can somebody help us with this problem otherwise we have to go back to Excel
2003 !!!!!!!!!!!!!!!!!!!!!

Lets pray to have a answer and solution to this bug.