Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel chart from a table
Hi All:
Is there a way to convert a two axis table into a chart without first putting all the data into one column? I have the following data from the Bureau of Labor Statistics (industrial building employees) ... Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 1990 191.8 191.1 191.8 195.8 199.7 204.8 206.0 207.9 208.1 206.3 200.6 192.6 1991 180.2 179.8 181.1 186.6 189.5 189.9 190.4 192.8 194.7 191.2 184.2 180.2 1992 170.4 168.7 172.3 175.3 179.3 180.3 181.1 182.1 182.3 185.3 180.3 172.7 1993 162.7 164.7 165.9 170.1 174.9 178.5 181.0 182.7 183.5 186.2 182.9 177.9 1994 168.6 168.0 174.2 181.7 185.7 188.1 190.5 191.4 194.5 196.2 194.5 188.8 1995 179.3 176.1 181.3 186.0 188.4 193.1 195.5 197.1 199.7 201.9 196.5 190.0 1996 179.5 179.4 186.8 192.4 196.8 201.1 202.8 204.0 204.8 205.2 202.5 196.6 1997 185.3 187.8 190.6 196.5 201.3 204.0 206.4 208.1 208.4 210.8 208.2 204.7 1998 196.4 196.6 200.0 205.9 210.9 216.3 220.0 221.0 218.8 222.3 219.2 213.5 1999 201.6 202.2 202.6 206.9 209.0 213.9 216.3 216.2 216.0 216.6 214.1 210.9 2000 203.0 202.1 206.2 210.5 213.6 219.6 221.1 222.2 220.1 220.7 215.9 209.1 2001 202.4 203.5 206.8 209.0 213.7 211.0 211.7 212.0 208.7 209.0 208.9 206.7 2002 195.2 191.9 190.9 189.9 194.0 192.9 192.9 196.0 192.9 190.2 186.2 185.1 2003 179.2 174.7 173.4 173.6 176.7 173.2 172.4 174.3 176.0 176.0 173.9 173.5 2004 166.5 158.1 160.2 163.4 169.5 170.0 171.9 168.2 171.5 175.2 172.9 168.1 2005 163.7 163.4 160.5 162.2 162.5 161.1 161.9 163.7 164.1 167.6 166.5 160.1 2006 156.6 155.0 157.2 164.2 163.8 164.7 164.4 0.0 .... as you hopefully can see, it has the months along the top row and the years down the left most column and I'd like to create a one line chart beginning at Jan 1990 ending at most recent data w/out first converting this table into two columns (dates and data). It would save me a lot of time if I could find a simpler way of making this chart w/out the intermediate step of recreating this table in column form using hlookup and match. Thanks v much. / Avi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Sorting values in a bar chart | Charts and Charting in Excel | |||
Using Microsoft Excel Chart object in VB6 | Charts and Charting in Excel | |||
pie-charting non-numeric data | Charts and Charting in Excel | |||
changing proportion of chart and data table | Charts and Charting in Excel |