Thread: Excel chart from a table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
James Silverton James Silverton is offline
external usenet poster
  
Posts: 182
Default Excel chart from a table
Hello, !
You wrote on 10 Oct 2006 06:07:25 -0700:

a Is there a way to convert a two axis table into a chart
a without first putting all the data into one column?

a I have the following data from the Bureau of Labor
a Statistics (industrial building employees) ...

a Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
a 1990 191.8 191.1 191.8 195.8 199.7 204.8 206.0 207.9
a 208.1 206.3 200.6 192.6

It would depend some on how the data is stored. Is it a flat
ASCII file (text)? Then simply importing it into Excel and
defining the delimiter as a space should do it. You might want
to place a header for the year in the first place on the first
line to ensure alignment.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

Reply With QuoteReply With Quote