Creating charts - first row&column treated as normal data

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

Guest

I have organized the data in a table that has in the first column the years,
in the first row the periods and in the other cells the respective sales.
Problem: when I select the entire table and use the Wizard to create a bar
cart, the first column is treated as the others columns and plotted in the
chart as an additional series.
I know I can correct this manually in the step 2 of the wizard, but I rather
prefer a system that automatically recognizes that the first column and row
are not data, but labels.
I have Excel 2003. With old versions I believe it was enough giving a
different formatting to first row and column.
Thanks
Enzo
 
Enzo:
Check if you left the left upper cell of your selected table empty. Excel
should then treat the first column and first row as labels I think.
HTH
Henk
 
I have organized the data in a table that has in the first column the years,
in the first row the periods and in the other cells the respective sales.
Problem: when I select the entire table and use the Wizard to create a bar
cart, the first column is treated as the others columns and plotted in the
chart as an additional series.
Click to expand...
I know I can correct this manually in the step 2 of the wizard, but I rather
prefer a system that automatically recognizes that the first column and row
are not data, but labels.
Click to expand...

I used to get this a lot, until I realised I was using the upper left
cell to label the first column. Excel doesn't know how to interpret
that. Since I startd making sure to keep the upper left cell blank when
creating a chart using Chart Wizard, it has stopped misbehaving.

Have you got content in the cell at the top of the first column?
 
You are right. After removing the text in that cell, the wizard works.
Thanks!
Click to expand...

You're welcome. Henk had the same thought.

Also, the more cells you leave blank in the upper left, the more rows
and columns the wizard will put in the category axis and the legend.

a b c
d e f
g h i
k l m 1 2 3
n o p 4 5 6
q r s 7 8 9
 
Back
Top