A colleague has drawn it to my attention that Excel 97 is much less friendly
when it comes to drawing charts of Pivot Tables. The example she cited was
of a table which had nominal categories (e.g. Group 1, Group 2, etc) as rows
and discrete numerical categories (e.g. 1, 2, 3, etc) as columns. In Excel
5 one could select the entire table minus grand totals and get a default bar
chart (either compund or component) that looked fine. In Excel 97 it is
firstly non-trivial to select a subset of the table and, having done so, it
mistakenly assumes that the row of column labels (1, 2, 3, 4) is an
additional series. Of course, with a lot of messing about with the series
you can sort it out, but it does seem to be a step backwards from Excel 5.
The solution would probably be to remove the Grand Total row and column
before charting, but that is a rather annoying imposition.
Has anyone else noticed this to be a problem - or a better way of solving
it?
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
|