Chart does not read imported data as number

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

Guest

Each week I import a data from a web page as an Excel spreadsheet. This spreadsheet is linked to a second workbook that I use to create charts. The data in both spreadsheets is formatted as 'number', but the charts read the value as zero. Any help would be very much appreciated!!
 
When you import the data, are you using import wizard and definately marking
that column of data as number? Most data is imported as text.

Easiest way to change it to number after you import - select a blank cell, copy,
select your range of numbers, Edit Paste Special Add

: Each week I import a data from a web page as an Excel spreadsheet. This
spreadsheet is linked to a second workbook that I use to create charts. The
data in both spreadsheets is formatted as 'number', but the charts read the
value as zero. Any help would be very much appreciated!!
 
Back
Top