My own error;
The selection for categories was wrong and therefore the last two data
points didn't show...
Thanks 4 your help!
/kk

"ShaneDevenshire" wrote:

Hi,

Based on your response to Jon's question I'm not sure what you mean when you
say "when I separate the data into two series"? from you response to Jon/s
question it sounds line you have three rows of data feeding your chart, one
with category info and two for series. So when you say separate the data
what exactly do you mean?

I created a line chart in 2007 with titles in A1:S1 and one series in A2:S2
and the second in A3:S3. After plotting it, I selected one of the series and
choose Format, Format Selection, and under Series Options chose Secondary
Axis. Everything is just fine.

Based on your description I can't duplicate the problem.

--
Thanks,
Shane Devenshire


"kkarre" wrote:

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