merging two worksheets into one pivot chart

I�m trying to merge to worksheets into one pivot chart. But i someho
don�t get to choose which fields I can put where in the table. If I us
the multiple consolidated option the wrong items are put on th
horizontal axis. What am i doing wrong

Kirstykop's Profile:
View this thread:

7/20/2005 10:00:28 AM
excel.charting 18370 articles. 0 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 2

You're not doing anything wrong. If you create a Pivot Table from 
multiple consolidation ranges, as you discovered, you won't get the same 
pivot table layout that you'd get from a single range. There's an 
example here:

If possible, store your data in a single worksheet, and you'll have more 
flexibility in creating the pivot table.

Kirstykop wrote:
> I�m trying to merge to worksheets into one pivot chart. But i somehow
> don�t get to choose which fields I can put where in the table. If I use
> the multiple consolidated option the wrong items are put on the
> horizontal axis. What am i doing wrong?

Debra Dalgleish
Excel FAQ, Tips & Book List

dsd1 (5911)
7/20/2005 12:13:44 PM

Similar Artilces:

Off by one transaction
When we are posting to the General Legder, the control # of transactions are off exactly one transaction to the actual # of transactions. We don't understand why this is so because we physically counted the transactions and the actual # of transactions are correct but the control # transactions are off by one. We posted anyway because we physically counted them, but for future use we would like to know why the # of transactions are off by one. If you have an answer to our dilemma please respond back. Much Appreciated, Matt Barran Matt: The Control Total is a number you enter,...

Linking Time-varying charts
Hi all, Here's my problem. I've got a set of Excel files with monthly data which is updated every month. So in January I only have Jan data. In February I have Jan and Feb data, and so on. The chart I have for this data always displays a full 18 months data from October 2003 to March 2005, and as more data is added, the line on the chart snakes its way from left to right. These files are submitted to me from various sources. As a central data collector, I now want to link these Excel files into a single Excel file which will display all the charts in one place for convenience. Ho...

One column with different widths
I want to make Column A with rows 1-29 one width and rows 30 and above another width. -- Calpitor Excel does not allow varying widths of cells within a column (or heights within rows). You could used 'Merged' cells to accomodate the wider column needs. HTH -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: View this thread: ...

merging pictures into a document template
I need help inserting a code on the data source for a merge that involves photographs. The mini-project is to take data and picture unique to each document. I did some instructions but I guess I"m such a newbie that I can't figure out where to start in this process. I'll paste the instructions below so somebody can tell me exactly, from the first step and every step til the end, how to do this. For me, there isn't enough info for me to follow the directions. I get stuck at #3. Specifically, "by nesting the merge field in an IncludePicture field." Where ...

Cutting and Pasteing from One spreadsheet to another.
Im trying to make up several templates that contain simliar data references. I want to cut from one template to another a number of cells. eg I have the following in one spreadsheet. =Info!G5 =Info!G6 =Info!G7 =Info!G8 =Info!G9 =Info!G10 =Info!G11 etc I simply want to cut this text exactly as it is and paste it into another spread sheet. However when I do I get the following ='C:\Documents and Settings\All Users\Templates\_Test_Excel_Access_Merge\[S8-R200a.xls]Info'!G5 ='C:\Documents and Settings\All Users\Templates\_Test_Excel_Access_Merge\[S8-R200a.xls]Info'!G6 etc. Re...

Q: Referencing named cells in external worksheet ?
Using Excel 2002. I have a workbook with 12 worksheets (one for every month of the year), wherein a lot of the information is looked-up (using VLOOKUP) in simples arrays. I saw no point in implementing the arrays as a 13th worksheet, because I will have a yearly version of my monthly worksheets in one workbook (so one for 2003, 2004, etc). If I change the array(s), I want them to be reflected in all referencing cells. Problem: If my workbook containing my arrays (called "Global") is loaded, I have no problem and the references to it read as: (blabla) 'Global.xls'!Roster ...

how to set up a worksheet for unlimited entries?
I need to set up an excel worksheet where the data in the "Cost" colum is added up to show "Total Cost" at the bottom of the column. I can d this very easily for a static range but the "cost" column is no static, it will keep on growing. How do I write a formula for "Tota Cost" which will be aware of how many entries exist in the column s they can be added up. Also, I was going to have "total cost" cell a the bottom of the "cost" column, can "Total Cost" be set up in such way, that the "Total Cost" cell moves dow...

Adding Lines And Boxes, etc. To A Chart ?
Hello, Will blame it on my age. Using Excel 2007 (or, at least trying to) and XP. When I have a chart page opened up, how do I get it to show the bar on the bottom (that the real old versions had) that allows one to click on one of its icons shown to "draw" lines, arrowed lines, boxes, add text with a box, etc on the chart itself ? Thanks, Bob Hi, With the chart selected you can use the Insert tab > Illustrations > Shapes. To add shapes to the chart. Textbox is in the Text group of the Insert tab. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypo...

Change background color of query results from access in worksheet
Hi, I have Excel 2007 and selected Date => From Access and then navigated to an Access DB and selected a query. I chose "Table" view. The query results now appear in my worksheet which is great. However, I want to change the background. Right now it alternatives by row between a light blue and a darker blue. I want the results to have a white background with black borders but have been unable to change the format. If I go to Home and select No fill for a color background nothing happens. Is there a way to change the query results? Thanks, Could be the r...

How to print a multiple page two sided small booklet, 4.5x5.5"
Publisher 03 has a folded card that uses standard 8.5x11" paper and after printing folds to a card size 4.5 x 5.5" What I need is to create a non folded "booklet" version which can have multiple pages (more than 8), printed on front and back. Essentially the same as the 8.5x5" program booklets (found in File/Page Setup/publication type:booklet) which print multiple pages now, but smaller and capable of printing front to back pages to either be folded into a booklet (one fold on center pages) or cut and bound into a booklet. I'm trying to build a small boo...

Chart Type HELP!
Hi, I still need help on the Chart Type thread that I posted a couple of hours ago under "Chart Type". It is URGENT--for a presentation for which I am already late!! Anybody?? Tx, Sat Hi Sat - Take a look at what I just posted and see if it helps. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ----------------------------------------------------------------------...

Combination chart? Stacked cylinders and scatter
Hi, I want to make a stacked bar chart that also shows another data point as a single point along the stacked bar. Here is what I have so far '[img=]' ( Here is what I want to accomplish: - don't show Sections where Length is zero -- right now the zero sections show with label and value on the right side of the cylinders - show another data point (from another cell in my sheet) as a single point along the stacked bar - show a final data point as the total of the bar len...

Problem with line Chart
I have the following data: Date Value 1/07 700 3/07 550 9/07 600 10/07 550 7/08 500 9/08 700 2/09 750 8/09 600 I would like to create a simple line chart connecting the Value points. Note that the points correspond to random dates (not evenly spaced). How can I create a line chart that has time on the x-axis, (say shown in months) with a line connecting the Value points, which are shown at various locations in time. Soun...

Web Posting Interactive worksheet
I created a very small excel file that I saved as a web page (calculations.htm). More specifically, when I saved it I selected Republish Sheet and add interactivity, then saved it to my desktop. When I opened it up on my desktop everything looked fine. However, when I posted it to my website, as I do will all my new htm pages, the data would not appear. Any suggestions? By the way, the file is a series of calculations that ask for a user to input their weight and I calculate what their daily calorie intake is. Very simple. CP ...

No "Chart Option" feature in the Formatting Palette or when double click on Chart
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I have read a discussion board concerning this issue but it was from 2008 and no solution was offered yet. The problem is as follows: one creates a graph but cannot add a title or format the axis etc. <br><br>When I open a new spreadsheet and enter the data, I can create the graph. However, I cannot select the &quot;Chart Option&quot; to change any specific features. On the formatting palette I only get the "Page Setup" options but nothing relating to the chart and when I double click on the graph t...

Check Boxes and Radio buttons on Worksheet
I just discovered that I can drop check box directly on a worksheet. I can make it do what I want, in a single instance, but I was wondering there was a way to make them act like formulas, in that I would like to attach the checkbox directly to a cell physically, and, incorporate it's TRUE/FALSE output in a formula, then be able to copy a whole row or column of cells containing the checkbox and formula ...and other data perhaps in a very general way. in other words havethe control behave as if it were the contents of a cell...Make sense? I don't want to have to write code or ...

Pivot tables, linking to a named range as a source to a pivot table
I have created a main worksheet within the same workbook of many pivot tables, and I want to use this same worksheet as the source of information to these different pivot table sheets off of which I create charts. I want to use a named range because there are over 4,000 rows in this main worksheet. I am not sure if I need a "=" to start the reference or what to do. I thought I should just use nameofworksheet!database if I name the range "database", but when I point and click to the sheet, it is just inserting the name "database" without the name of the...

Merged Cells
I have imported data into Excel. The left-hand column has merged cells containing a reference number. The remaining columns contain varying records associated with the reference number, a one to many ratio. I need to display the worksheet so that the appropriate reference number is displayed in the left-hand column for each of the records in the worksheet. There are hundreds of reference numbers. Is there an automated way to do this besides unmerging each section and copying the reference number into the now unmerged cells? Thank you. ...

Duplicate emails received (two copies)
I am receiving two copies of each received email. What could cause this problem? Thank You, Dan ...

Rollup worksheets into a master worksheet
I would like to have three different people update their own product lines within a master workbook. The master worksheet needs to retain sorting ability. Is there a formula or macro I can use to pull this information from three individual worksheets into the master workbook, based on the user name? The master worksheet would then become "read only". * All column headers are the same * The workbook would contain these worksheets: Master, Cathy, Laura, Tonya Thanks for your consideration. ...

Help with combining 2 seperate Worksheet Change Event scripts
Hi, I have 2 seperate Worksheet Change Event scripts that I would like to combine to use in one woeksheet and I'm sure how to do. I am kind of new to VB. The first script is for hiding columns based on a value selected in picklist. Private Sub Worksheet_Change(ByVal Target As Range) 'SalesAid Software If Target.Address <> Range("L2").Address Then Exit Sub 'MsgBox Month(Target) If Target = "All" Then Range("N:BV").EntireColumn.Hidden = False Else lastcol = Cells(6, Columns.Count).End(xlToLe...

how do I arrange multiple worksheets from the same workbook
I want to open multiple worksheets from the same workbook and tile them horizontally. I know you can do it with multiple workbooks, but i can't open worksheets from the same workbook. Any ideas? try <Window><New Window> Yow will see two views in the same workbook which you can manipulate separately. If you delete one view the data is not disturbed. If you save while showing the two windows, It will open with two windows when you reopen the file. "skytags" wrote: > I want to open multiple worksheets from the same workbook and tile them > horizontall...

WEEKNUM in pivot returns 1900-01-31
Hi! I'm sitting with an excel pivot that has one column (Weeks) which originates from fields formatted like this: =WEEKNUM(G445;2). But in the pivot, the field magically converts into 1900-01-31 (Swedish date)! It looked alright to me until 1 Augusti, when the weeknumber changed from 31 to 32. Then it restarted from 31 to 1 :( I've tried to change the original formula to =TEXT(WEEKNUM(G445;2);0), but the pivot can't sort the list properly, thinking that 21 comes after 1... Any ideas? Thanks alot! /Martin If you just format that field (in the pivottable) as General, what do you...

How to credit complicated pie chart
I want to create a pie chart of my credit card statement each month. Every pie chart example shows 3 columns and about 5 rows of data. I can create a chart for something that simple but what I need is A chart showing the amounts and to what merchant that amount was spent at. Can someone point me in the direction where I can find something that would tell me how to do what I want? Thanks Ron ...

Merging html files
Hi I need to merge outlook signature and stationery files to create one html file for mail shot from within Access via outlook. Is there code sample somewhere that demonstrates how to merge the two signature and stationery html files into one? Many Thanks Regards ...