I prefer the first option, since I'm too lazy to delete and retype the
header values. Often I put them in the row above the Y column headers,
leaving blanks above the X column header(s). The trick with blanks
works out nicely too if you want multiple row category labels. If you
use two blank cells (say FG had another row, with some other info about
his weeks), if the blank region is two rows high, the first two rows
will be used in the chart:

Data:

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

Chart:

50 |
40 |
30 |
20 |
10 |
0 |______|______|______|______|
11 12 13 14
A B C D


- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______



Father Guido wrote:
On Wed, 01 Oct 2003 10:32:00 GMT, Tushar Mehta
wrote:


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


WOW!!! Thanks a million Tushar, you made my day. Both solutions are
great, the first if you are creating the chart by selecting the data and
pressing F11, the second as you say, using the Chart Wizard.

Thanks again,

Norm

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