Graphing errors due to data from different sheets

N

NavyPianoMan

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.
 
J

Jon Peltier

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
 
N

NavyPianoMan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Overlay line graph points on bar graph 1
Copy column from different sheets and plot a graph 3
Excel 2003: Duplicate dashboard and data sheets 0
Line charting the same series using data from multiple sheets? 1
Copy Graph But change Data Sheet 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Accumulative sheet data 5
Changed data lables in graph from 0% to blank or N/A 0

Top