E
ExcelProf
We're unable to generate a usable chart from our table with year
(numeric values) as the column headings and numerical values as th
data series to be charted. Using Office2002.
e.g. 2001 2002 2003 2004
........10000 8000 12000 11500
Both ranges appear as data series.
I've tried extensive variations of possibilities in the Chart Wizar
Step 2 Series dialogue box, with no luck.
The only way I can make the years work as labels is to change to tex
in the table, e.g. '2001 '2002 '2003 '2004
But that's not optimal since the data is imported as end of fisca
period dates and formatted as year only. Would have to take anothe
step to convert to text.
Any suggestions?
Thanks very much, ExcelPro
(numeric values) as the column headings and numerical values as th
data series to be charted. Using Office2002.
e.g. 2001 2002 2003 2004
........10000 8000 12000 11500
Both ranges appear as data series.
I've tried extensive variations of possibilities in the Chart Wizar
Step 2 Series dialogue box, with no luck.
The only way I can make the years work as labels is to change to tex
in the table, e.g. '2001 '2002 '2003 '2004
But that's not optimal since the data is imported as end of fisca
period dates and formatted as year only. Would have to take anothe
step to convert to text.
Any suggestions?
Thanks very much, ExcelPro