View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default multiple headers in data table

Hi,

yes, but it doesn't look that great. Try laying your data out like this and
then charting it.

Position Name Amt
Mgr Student1 2
Student2 4
Student3 1
Student4 2
Student5 8
Staff Student6 1
Student7 1
Student8 2
Student9 8
Student10 8
Actor Student11 5
Student12 9
Student13 2
Student14 6
Student15 4

Personally, I am in favor of putting the data below the chart in the
spreadsheet and printing them both a the same time. Then you have 100%
control of the elements in the "data table".

If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Corvus" wrote:

Hi,

I need to have my data table header row split into 2 separate rows. one for
a name, the next row for their position.

Is this possible, or will i have to make it work with just the one row?