Charts not working after pasting table from html page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
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
 
Thanks Gord

Excel is obvioulsy not so smart any longer

Just puzzled why microsoft has not fixed this issue: This must be a pretty common problem that people will copy html tables and it should not require more than simple reformating when we speak 2004

Thanks to you and others for helping me out.

----- Gord Dibben wrote: ----

Tron

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 o
data then Paste Special>Add>OK>Esc

After this, you still may not get the results you want. In that case, ther
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#trimal

Gord Dibben Excel MV
 
Back
Top