How the heck do I plot 'my text' for the X axis? (instead of 1, 2, 3, 4 etc.)

Option 1: Delete the word Week and use the Chart Wizard. For some
unexplicable reason, if XL finds an empty cell in the first row (or
column) it assumes that is the x-axis values, otherwise it assumes all
rows (columns) are y-values. Once the chart is complete put the
contents of the deleted cell back.

Option 2 (and my preferred choice): Leave the data alone. In step 2 of
the wizard, click the Series tab. In the Series field select the first
row (column). Copy the Values field into the 'Category (X) axis
labels' field. Click the Remove button.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi,

I'm using XL2002 & Win2000Pro.

How can I display the week numbers (as shown) in the x axis, rather than
1, 2, 3, 4 etc. that M$ uses.

Here's my data

Week 11 12 13 14
Sales A 43 55 48 32
Sales B 32 36 41 29

Here's what I want the axis's to look like

50
40
30
20
10
0
11 12 13 14

How do I do it?

Many thanks!!!

Norm

Father Guido
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
I plan on living forever... so far, so good