Here's what I did. I put 18 labels in A1:R1 and 18 values in A2:R2. I made a
line chart, no problem.

I dragged cells Q2:R2 down a row to Q3:R3. Naturally they fell off of the
chart (though the chart still had 18 points). I used A3:R3 as the Y values
for a second series, and the last two points showed up right where they had
been at the end of the other series. Changing this series to the secondary
axis did not affect whether the points appeared or not.

What did you do differently?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"kkarre" wrote in message
...
Line chart
18 data points
2 of them moved to a new row=new series
3 rows (2 series + 1 category axis)
/Kristian

"Jon Peltier" wrote:

What type of chart?
You have 18 columns, how many rows, where are your X values or labels,
are
you plotting by row or column?
How are you splitting this into two series?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"kkarre" wrote in message
...
Hello,
Does anyone know if this is a "known feature" of Excel 2007:
I have selected a data arera of, say, 18 columns.
My chart obediently displays all the data.
When I separate the data into 2 series and add a 2nd value axis the
following happens: The chart drops the last two data points of the
data!

Am I
-missing a new setting,
-fighting in vain against a bug or
-missing something?

Grateful for any tip,
Kristian