View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
[email protected] avifisher@gmail.com is offline
external usenet poster
 
Posts: 3
Default Excel chart from a table

Thanks for the response but I'm probably not being clear

I do not have a problem getting the data into excel. I'm trying to
determine how to make a line graph going from jan 1990 to present w/out
having to first reformat the table into a single long column or row.

Thanks / Avi


James Silverton wrote:
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