Weird issue with very simple line chart - urgent
 

Hi everyone - I have a very simple data that I want to chart on a line. Two
rows of data, 10 columns (years from now until 2017), simply showing the
values of two items.

I want a line graph to show how these values compare over time.

But when I chart them, one of the series is fine, but the other seems to
just "add" its value to the first. So, for example, in 2010, series A value
is 50 and series B value is 70. But on the graph, series B is shown as 120
on the Y axis.

When I chart it on the secondary axis, it is fine.

What am I doing wrong!!

Weird issue with very simple line chart - urgent
 

Probably you selected Stacked line from the Chart sub-type list. Change it to
simple Line!

Regards,
Stefi


€žTotteridge Ram€� ezt Ã*rta:

Hi everyone - I have a very simple data that I want to chart on a line. Two
rows of data, 10 columns (years from now until 2017), simply showing the
values of two items.

I want a line graph to show how these values compare over time.

But when I chart them, one of the series is fine, but the other seems to
just "add" its value to the first. So, for example, in 2010, series A value
is 50 and series B value is 70. But on the graph, series B is shown as 120
on the Y axis.

When I chart it on the secondary axis, it is fine.

What am I doing wrong!!

Weird issue with very simple line chart - urgent
 

Duh!!

Thanks a lot Stefi, this has worked fine. I was going round the twist!!

"Stefi" wrote:

Probably you selected Stacked line from the Chart sub-type list. Change it to
simple Line!

Regards,
Stefi


€žTotteridge Ram€� ezt Ã*rta:

Hi everyone - I have a very simple data that I want to chart on a line. Two
rows of data, 10 columns (years from now until 2017), simply showing the
values of two items.

I want a line graph to show how these values compare over time.

But when I chart them, one of the series is fine, but the other seems to
just "add" its value to the first. So, for example, in 2010, series A value
is 50 and series B value is 70. But on the graph, series B is shown as 120
on the Y axis.

When I chart it on the secondary axis, it is fine.

What am I doing wrong!!

Weird issue with very simple line chart - urgent
 

You are welcome! Thanks for the feedback!
Stefi

€žTotteridge Ram€� ezt Ã*rta:

Duh!!

Thanks a lot Stefi, this has worked fine. I was going round the twist!!

"Stefi" wrote:

Probably you selected Stacked line from the Chart sub-type list. Change it to
simple Line!

Regards,
Stefi


€žTotteridge Ram€� ezt Ã*rta:

Hi everyone - I have a very simple data that I want to chart on a line. Two
rows of data, 10 columns (years from now until 2017), simply showing the
values of two items.

I want a line graph to show how these values compare over time.

But when I chart them, one of the series is fine, but the other seems to
just "add" its value to the first. So, for example, in 2010, series A value
is 50 and series B value is 70. But on the graph, series B is shown as 120
on the Y axis.

When I chart it on the secondary axis, it is fine.

What am I doing wrong!!