I have been given an example of a report that I need to replicate. The data
is a national distribution by region and then by state; each region shows a
percentage of total. I've got the calcs OK but I need to arrange the data to
repeat the 3 data columns side by side. each region with a header, and a
subtotal so that half of the report is on the left and half on the right.

On Mon, 20 Aug 2007, in microsoft.public.excel.charting,
sailorgirl said:
I have been given an example of a report that I need to replicate. The data
is a national distribution by region and then by state; each region shows a
percentage of total. I've got the calcs OK but I need to arrange the data to
repeat the 3 data columns side by side. each region with a header, and a
subtotal so that half of the report is on the left and half on the right.

This is microsoft.public.excel.charting, for discussing making graphs
using Excel. It's not really the right place for questions about making
spreadsheets. Have you tried microsoft.public.excel.misc?

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.