When I try to graph data from two different sheets, the program is producing
erroneous results. I'm trying to use a bar graph to show progress (or
decline) in scores from one physical fitness test to the next. The graph is
showing no data for person 11, even though they DO have data in at least one
of the sheets.
The error might be due to the fact that while the people are the same on
both sheets (same number and order), some on the first sheet don't have
results while they do on the second (and vice versa) and some didn't take
part in either test. Could this have an effect or is there something else
I'm doing wrong? I'm defining both columns using the "Series" function.

Are you trying to combine information from more than one sheet in a single
series? That could be your problem. The easiest way to handle this issue is
to compile a summary sheet which links to the data on the original sheets,
then make the chart from this summary. It's easier to add the data to the
chart, it's easier to see what's happening, and the chart won't complain.

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


"NavyPianoMan" wrote in message
...
When I try to graph data from two different sheets, the program is
producing
erroneous results. I'm trying to use a bar graph to show progress (or
decline) in scores from one physical fitness test to the next. The graph
is
showing no data for person 11, even though they DO have data in at least
one
of the sheets.
The error might be due to the fact that while the people are the same on
both sheets (same number and order), some on the first sheet don't have
results while they do on the second (and vice versa) and some didn't take
part in either test. Could this have an effect or is there something else
I'm doing wrong? I'm defining both columns using the "Series" function.

I can copy the data to a new sheet, but I get a #REF error. How do I link
the data to the other sheets?
Thanks,
NavyPianoMan

"Jon Peltier" wrote:

Are you trying to combine information from more than one sheet in a single
series? That could be your problem. The easiest way to handle this issue is
to compile a summary sheet which links to the data on the original sheets,
then make the chart from this summary. It's easier to add the data to the
chart, it's easier to see what's happening, and the chart won't complain.

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


"NavyPianoMan" wrote in message
...
When I try to graph data from two different sheets, the program is
producing
erroneous results. I'm trying to use a bar graph to show progress (or
decline) in scores from one physical fitness test to the next. The graph
is
showing no data for person 11, even though they DO have data in at least
one
of the sheets.
The error might be due to the fact that while the people are the same on
both sheets (same number and order), some on the first sheet don't have
results while they do on the second (and vice versa) and some didn't take
part in either test. Could this have an effect or is there something else
I'm doing wrong? I'm defining both columns using the "Series" function.

Copy, Paste Special, Paste Link.

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


"NavyPianoMan" wrote in message
...
I can copy the data to a new sheet, but I get a #REF error. How do I link
the data to the other sheets?
Thanks,
NavyPianoMan

"Jon Peltier" wrote:

Are you trying to combine information from more than one sheet in a
single
series? That could be your problem. The easiest way to handle this issue
is
to compile a summary sheet which links to the data on the original
sheets,
then make the chart from this summary. It's easier to add the data to the
chart, it's easier to see what's happening, and the chart won't complain.

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


"NavyPianoMan" wrote in message
...
When I try to graph data from two different sheets, the program is
producing
erroneous results. I'm trying to use a bar graph to show progress (or
decline) in scores from one physical fitness test to the next. The
graph
is
showing no data for person 11, even though they DO have data in at
least
one
of the sheets.
The error might be due to the fact that while the people are the same
on
both sheets (same number and order), some on the first sheet don't have
results while they do on the second (and vice versa) and some didn't
take
part in either test. Could this have an effect or is there something
else
I'm doing wrong? I'm defining both columns using the "Series"
function.