Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
multiple headers in data table
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
multiple headers in data table
Thank you, that gets me most of the way there,
unfortunately doing the data table separately isnt an option in this case. Is it possible to make the second line in the row headers a separate set of cells? I've no doubt that this isnt a common question, but the requirements are somewhat strict in this instance. Thanks for your help so far "Shane Devenshire" wrote: 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? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
multiple headers in data table
Hi,
I probably don't understand, but the Position and Names are in different cells. Cheers, Shane Devenshire "Corvus" wrote: Thank you, that gets me most of the way there, unfortunately doing the data table separately isnt an option in this case. Is it possible to make the second line in the row headers a separate set of cells? I've no doubt that this isnt a common question, but the requirements are somewhat strict in this instance. Thanks for your help so far "Shane Devenshire" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table headers to remain on top | Excel Discussion (Misc queries) | |||
Problem formatting pivot table headers | Excel Worksheet Functions | |||
? Pivot Table from 3 columns of raw data with headers | Excel Discussion (Misc queries) | |||
multiple headers in excel | Excel Discussion (Misc queries) | |||
Headers on multiple pages | Excel Worksheet Functions |