View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
HEK HEK is offline
external usenet poster
 
Posts: 46
Default Creating charts - first row&column treated as normal data

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

"Enzo" wrote:

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