Charts not working after pasting table from html page

T

Trond Noren

After pasting a table from a webpage into excel 2003, it is imposible to make the charts function work as normal

When I retype the table manually, chart wizard works fine
Even formating the cells as text and numbers, the chart wizard does not work
Pasting special (text or unicode) and reformating the correct cells to numbers does not work
Looks like the Chart wizard treat the table as just one text-entry and one number

Drives me nuts....this worked on Excel 2000 so why does it not work here...

Must be one normal way to make this (typical task) work in Excel 2003?
 
F

Frank Kabel

Hi
try the following
- format your column as 'Number'
- select an empty cell and copy this cell (e.g. with CTRL+C)
- select your data column
- goto 'Edit - Paste Special' and choos the action 'Add'

this should force the conversion of your entries to numbers


--
Regards
Frank Kabel
Frankfurt, Germany

Trond said:
After pasting a table from a webpage into excel 2003, it is imposible
to make the charts function work as normal.

When I retype the table manually, chart wizard works fine.
Even formating the cells as text and numbers, the chart wizard does
not work.
Pasting special (text or unicode) and reformating the correct cells
to numbers does not work.
Looks like the Chart wizard treat the table as just one text-entry
and one number.

Drives me nuts....this worked on Excel 2000 so why does it not work
here...?

Must be one normal way to make this (typical task) work in Excel
Click to expand...
2003?
 
G

Gord Dibben

Trond

The numbers may have been imported as text. Simply re-formatting to "number"
will not change them.

Format an empty cell to number or general. Copy it and select your range of
data then Paste Special>Add>OK>Esc.

After this, you still may not get the results you want. In that case, there
could be HTML non-breaking space characters(160)in the data.

See David MCritchie's TRIMALL macro for further cleaning.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Gord Dibben Excel MVP
 
Top