x-axis data labels

  • Thread starter Thread starter michael
  • Start date Start date
M

michael

Hello,

I have 4 products w/3 yrs of data for each product. The x-
axis label is the product and above that I would like to
put the yr under each column. How can I do this?

Help please...

Thanks
 
Michael -

You can use multiple columns in the worksheet for category labels. This
sample data:

a b c
Alfa 2000 10 11 12
2001 11 12 13
2002 12 13 14
Beta 2000 13 14 15
2001 14 15 16
2002 15 16 17
Gamma 2000 16 17 18
2001 17 18 19
2002 18 19 20

has the product names in the first column and the year in the second.
Note that the cells atop these columns are blank; these blanks help show
Excel what you want done with the data. Select the range and make your
column chart. The X axis is labeled thus:

2000 2001 2002 2000 2001 2002 2000 2001 2002
Alfa Beta Gamma

- Jon
 
Back
Top