Data from copied from Access graphs blanks as zeros when copied to excel

M

Matt Johnson

I did a crosstab query in Access and used the Office Link in Access t
open the results in Excel.

Then I selected several rows of data in excel and produced a llin
chart...

Several of the cells within the crosstab query were blank and each o
these graphed as a zero which screwed up the grapf...

I have the settings in Excel such that blanks cells should graph a
missing points not zeros, but that does not seem to work. from readin
this forum I get the idea that not all blank fields are created equa
and some graph while others do not...

My question is this...is there a way (without VBA etc) to either tel
excel to not graph the empty cells OR to concert the "bad" empty cell
to "good" empty cells.

Hopefully this question does not sound too retarded...that for any hel
you can provide!

Mat
 
J

Jon Peltier

Matt -

I suspect that these cells are not blank, but instead contain "", an
empty string. When charting, strings are interpreted as zeros. To pick
pseudo-blanks out of a range of numbers, select the range, press Ctrl-G
("Go to"), click on Special, and select Constants and only the Text
checkbox under Formulas, and press Okay. With just these selected,
press the Delete key.

- Jon
 

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