Axis labels from data

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

Guest

Col A has years, such as 1990 thru 2003.
Col B has numbers relevant to each year. Sales, taxes, inventory, whatever.
I want a simple bar chart where the numbers are represented by the bars left to right. Easy.
I want the categoty (X) axis label values to be 1990, 1001, etc instead of 1,2,3,... Not easy, or at least not obvious.
Any ideas on how to do this? It seems like it should be built-in simple, but I've searched everywhere (except where the explanation is) to no result.
Excel 2K Win 98 as well as Excel 2002 Win 2K.
Thanks.
 
Sorry, I kept looking after I posted and found it. It is simple, but perhaps not so visible. Step 2, "Series" tab, at the bottom.
 
Even easier to do if you use row headers. Put a title above the data in
column B but not above that in column A, so the data looks like this:

Value
1995 15000
1996 15600
1997 16350
1998 17100

etc.

Now select the range including the blank cell and column header, then
make your chart. The blank cell is a clue to Excel to use the column
without a header as the category labels and the row of the blank for
series names. To plot multiple series, just extend the column headers
and columns:

Value Val-2 Other
1995 15000 12125 14220
1996 15600 13000 15250
1997 16350 12500 14800
1998 17100 13125 14500

- Jon
 
Back
Top