The values won't show in the graph even though they show in the cell. What to do?

**droppe** · 05-10-2013, 09:50 AM

Hey folks.

My excel (2013) wont chart what i tell it to chart. Even though it's data in all the cells not all data show up in the graph. I tried to take away all formatting but it doesn't help. The thing is i can see something is different with the rows that excel wont chart, but i can't seem to find out what it is. If you can (i've included the file), please tell me.

Thanks!

/Åsa

**martindwilson** · 05-10-2013, 10:12 AM

you have spaces between digits so they are text and some trailing char 10s

**Norie** · 05-10-2013, 10:17 AM

Åsa

Some of the numbers in the table are actually text.

The main problem seems to be a space in any number more than 1000, also there are carriage returns at the end of some of the values.

You need to remove both the space and the carriage return.

I did it with this formula in C24:H35.

Formula:

Please Login or Register  to view this content.

I then copied the values from C24:H35 over the original data.

**droppe** · 05-10-2013, 10:32 AM

Thanks! I
yet don't understand how to use that formula, but i will try.

**Norie** · 05-10-2013, 10:38 AM

Put the formula in C24 and copy it down and across to H35.

Then select C24:H35, copy, select C11 and then Paste>Paste Special... Values.

**droppe** · 05-10-2013, 10:44 AM

I still dont get it to work :/ It just says the formel doesn't work. hmm.

**Norie** · 05-10-2013, 10:48 AM

You might need to change it based on your regional settings, eg replace , with ;.

Have a look at the attached, I've added the formulas.

**droppe** · 05-10-2013, 10:55 AM

Thanks! :D

**Norie** · 05-10-2013, 10:56 AM

No problem.

Just curious, but did the , change to ; in the formula?

**droppe** · 05-10-2013, 11:04 AM

Yep, and the english commands became swedish...! That made me wonder - if i have it in swedish settings, wont it recognize any english commands at all? Hmmm.

btw, it also worked with the function named clean (/rensa in swedish).

**droppe** · 05-10-2013, 11:07 AM

ps. now i can't find how to marke this thread solved. but it is. yay!

**Norie** · 05-10-2013, 11:08 AM

CLEAN (RENSA) removed the spaces as well as the carriage return?

**droppe** · 05-10-2013, 11:12 AM

euhm. just the carriage return, but not the space. Actually i think it made everything into text, cause now no values at all appear in the graph. hmpf.

The values won't show in the graph even though they show in the cell. What to do?

LinkBack

Thread Tools

Rate This Thread

Display

The values won't show in the graph even though they show in the cell. What to do?

Re: The values won't show in the graph even though they show in the cell. What to do?

Re: The values won't show in the graph even though they show in the cell. What to do?

Re: The values won't show in the graph even though they show in the cell. What to do?

Re: The values won't show in the graph even though they show in the cell. What to do?

Re: The values won't show in the graph even though they show in the cell. What to do?

Re: The values won't show in the graph even though they show in the cell. What to do?

Re: The values won't show in the graph even though they show in the cell. What to do?

Re: The values won't show in the graph even though they show in the cell. What to do?

Re: The values won't show in the graph even though they show in the cell. What to do?

Re: The values won't show in the graph even though they show in the cell. What to do?

Re: The values won't show in the graph even though they show in the cell. What to do?

Re: The values won't show in the graph even though they show in the cell. What to do?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions