| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot chart over two sheets of data
Hi,
I have a large amount of data that has to many lines for one sheet, so I had to put half of it on a second sheet. I would like to do a pivot over both sheets together so that i can have one pivot chart. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot chart over two sheets of data
You can create a pivot table from the data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want. There's more information he http://www.contextures.com/xlPivot08.html lindsayhyle wrote: Hi, I have a large amount of data that has to many lines for one sheet, so I had to put half of it on a second sheet. I would like to do a pivot over both sheets together so that i can have one pivot chart. Is this possible? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Data- Pivot on multiple sheets | Excel Discussion (Misc queries) | |||
| Pivot Chart/Sheet comparisons -- adding or subtracting sheets | Excel Discussion (Misc queries) | |||
| Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
| chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
| Chart sheets cause data sheets to be blank | Charts and Charting in Excel | |||
Linear Mode
