View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
sailorgirl sailorgirl is offline
external usenet poster
 
Posts: 2
Default state distribution chart in repeating columns

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.