Missing data and "invalid references"

J

Jordlaw

I am making several chart using the XY (Scatter) template. I have several
worksheets in the workbook. I am trying to plot my data on the last
worksheet. I either get an error saying that there are invalid references
and to check for incorrect format, formulas etc. And sometimes data will be
missing in the chart that I highlighted before I started the wizard. None of
the data I am trying to plot contains formulas. It is just entered as
numbers. I tried changing it from General to number under the format cells
option, but that did not work either. Can anyone help me?
 

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

Top