Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Creating a cell so data goes into a table | Excel Discussion (Misc queries) | |||
Help with pivot charts and data labels | Charts and Charting in Excel |