Pivot Chart Changes

I would like to have several charts based off of one pivot table. However, 
when I change the data in one pivot chart, all the pivot charts change 
similarly. Is there to have each chart seperate and distinct from one another 
and still be based off of the same pivot table?
0
JJ7759 (95)
10/21/2005 10:25:06 PM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
287 Views

Similar Articles

[PageSpeed] 46

No. You'll need a separate pivot table for each chart, if you want them 
to have different layouts.
When you create additional pivot tables, you can base them on the first 
pivot table.

JJ wrote:
> I would like to have several charts based off of one pivot table. However, 
> when I change the data in one pivot chart, all the pivot charts change 
> similarly. Is there to have each chart seperate and distinct from one another 
> and still be based off of the same pivot table?


-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

0
dsd1 (5911)
10/21/2005 10:41:50 PM
Reply:

Similar Artilces:

excel charts #14
i have a chart set up to chart data calculated from a formula, if no data is entered into the formula the chart plots that perticlar date as zero. How do set it up so nothing is plotted unless a value has been input? try this configure the formual so that blanks are enterd as #N/A "matsuda" <matsuda@discussions.microsoft.com> wrote in message news:16E56FCB-FCE0-4618-8CB0-DC74B1A53D6B@microsoft.com... > i have a chart set up to chart data calculated from a formula, if no data is > entered into the formula the chart plots that perticlar date as zero. How do > set...

Track Changes 03-12-10
Let's say I have added 10 words using track changes and then saved my document. Now I want to delete 2 of those words, instead of just deleting them it puts the strikethrough in those 2 words. Why and how do I stop it? This doesn't happen to all documents. Right-click the words and select Accept Change (or Accept Deletion) from the context menu. -- Stefan Blom Microsoft Word MVP "Flasho" <Flasho@discussions.microsoft.com> wrote in message news:F05E911C-7CA6-4DAD-A146-C712C8A5BDAA@microsoft.com... > Let's say I have added 10 words usin...

Change to Insert Drop Down Menu Items Office 2003 Win Vista Home P
When I click Insert>Auto Text>Signature in Word 32003, all of a sudden, beside many of the choices with an > I'm seeing the message Sign Into Office Live Workspace Beta. As I said, it's beside quite a few of the choices in this drop down list. If I click it, it does nothing. I did nothing to change this. Have I gotten an Update from Microsoft that changed something? Now why would Microsoft release an update that screws up Word Pro 2003. Are we pushing 2007 or 2010? Any answers to help restore this function to its working status is greatle appreciated. I alrea...

Creating a Pivot Chart
I am sure there is a pretty simple trick to this that I just cannot figure out. I would like to put these currencies into a pivot table and be able to filter by Country. My ideal situation would be able to set up a Pivot graph that I could pick and choose which currency I wanted to show using the report filter. Everytime I try I cannot get this result. My sheet is set up as the following. Colums have the Country Currency Ticker USD, JPY, GBP, etc with the values beneath them. The rows are labeled by date starting at 1/1/2006 to 10/22/08 starting in cell. The column labels start ...

Help with hierarchy in organization charts
I am trying to create a basic org chart for my organization. I am having difficulty representing people at different levels that report to the same person. For example, a manager and a director might report to a partner. I want the manager to appear lower on the chart than the director, but want a direct line to the partner above both people. I realize I can manually lower the manager, but when I use the re-layout function the manager is elevated back to the level of the director. Any ideas? This was easy to accomplish in OrgPlus and I assume there must be a way in Visio as well. Thanks!...

Map projection as an Excel chart
Can I download Excel chart based on a map projection? ...

column chart changes my data
Hi I have attempted to make a column chart with error bars using 6.3 0.008199 6.8 0.0151625 7.5 0.006469 as my data, BUT when i highlight and insert chart my figures (6.3,6.8,7.5) change to 1,2, and 3. and my other figures change to 1-8 I am trying to show rate of reaction vs pH level can anyone tell me what i am doing wrong as I dont normally have any trouble with these charts.I am using office 2003 -- thanks to all You should be using an XY chart for numerical value, particularly for scientific analyses. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Pelt...

Log-log charts #2
Hi, I'm using Excel 2002 and am trying to create a simple log-log plot. Making the y-axis logarithmic is easy - it's a check-box option under Scale tab of the Format Axis dialog. But for the X axis the dialog does not have that option. My XY data is valid (all positive values). There's web sites that say you can do this (e.g. http://cstl-cst.semo.edu/venezian/Utilities/graphs.htm). Why doesn't my Excel support it??? Any help is appreciated. Walt Hi Walt, Sounds like your chart maybe a line chart (x-axis is category) instead of true xy scatter. Right click the chart...

Keep conditional format when "show pages" from Pivot table
When I use "show pages" to drill down the data into pages from Pivot table, I find the conditional format on pivot table is missing. I have to make conditional format again to every page. How to keep the conditional formatting when I use "show pages" from pivot table? Maybe you could just apply Data|filter|autofilter to your original data range and filter to show what you need to see. Angus wrote: > > When I use "show pages" to drill down the data into pages from Pivot table, I > find the conditional format on pivot table is missing. I have to m...

How do I put a chart into a new sheet?
The version of excel I usually use has a prompt to put the chart into a new sheet, where you don't see the spreadsheet anymore. Does anyone know how to do that?W If you right click the chart (near the outer edge0 there is an option location. "Erica" wrote: > The version of excel I usually use has a prompt to put the chart into a new > sheet, where you don't see the spreadsheet anymore. Does anyone know how to > do that?W ...

ht change default directory for import/export
In Access 2007 is there a way to change the default folder location used for import and export? There's a "Default database folder" under the "Popular" Access options, but it only affects open/save and importing/exporting Access files (accdb and mdb). All the other import/exports (txt, xlsx, xml, etc.) all default to My Documents. Would love to change that, any help? ...

Variables in Chart titles?
Is it possible to include a variable/cell link in the title of a chart? My client is wanting the current date in each report run to show up in the chart title, and doing it by hand each time is a pain. Put the formula that builds the desired title text into a cell, then select the text element (it works for chart title, axis titles, data labels, and shapes), click in the formula bar and type =, then click on the cell. The formula bar should now look something like: =Sheet1!$A$1 but with the appropriate sheet and cell address. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials an...

How do I change the booking window?
I am trying to enter a recurring meeting beyond 1 year and it declines saying "I've gone beyond the booking window," which seems to be 1 year from the start date. Is there anyway to change this to 2 years or anything beyond 1 year? Thanks for any help. The admin needs to change it on the server. See http://www.slipstick.com/calendar/book180.asp -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com/ Outlook Tips by email: mailto:dailytips-subscribe-request@lists.outlo...

CRM 3.0
I would like to move the ordernumber middle part to a larger number to match the next available number in the existing paper order system. Where do I find the row/column in the database to change the seed or next available number? ...

Inbox unread total does not change
I have a problem with one Outlook installation in my office. The number on the right of the Inbox, which should reflect the number of unread messages, is the total of all the messages in the Inbox - both unread and read. How do I fix this? >-----Original Message----- >I have a problem with one Outlook installation in my >office. The number on the right of the Inbox, which should >reflect the number of unread messages, is the total of all >the messages in the Inbox - both unread and read. > >How do I fix this? >. >What version of Outlook are you running? ...

subform used for changing mainform record
Hello. I have a main form that has a tabcontrol on it. One of the tabs has a subform on it that will list the many of the mainform's one. This is a parent/child hierarchy set up. So the parents and children are all in one table. A parent can also be a child and a child can also be a parent. Anyway, below is the code that I originally used for making the change. Now it does not and I do not see why. The button that I am using is inside the subform that when used takes and changes the mainform to the selected record and the subform as well. The txtChangeRequestID is the...

Excel should let me organize charts in groups
When creating many charts in an excel sheet there is a need to organize them in a way to be easily dealt with. The proposal is to group those charts in a group cascaded after each other, each chart has a tap like the taps of the excel sheet which contain the name of the sheet. This group of charts may be minimized as an icon which can be dragged or cut & past in other excel sheet or any other office document. Also we need the ability format the group in one step instead of applying the format to each chart. ---------------- This post is a suggestion for Microsoft, and Microsoft resp...

How do I make x-axis dates in area chart not start from/drop to ze
When I create an area chart from with a date range as the x-axis, there are diagonals that take the chart to the data value for the first day, and from the last data value down to the axis. What I would prefer are verticals as the diagonals sure make it look like the chart has ended with a 0 y-axis value, or starts with a 0 y-axis value. Any ideas? Select the x-axis, and format. Adjust the scale to bring the chart into the boundaries you want. Note that you'll need to enter a serial number representing the date you want. -- Best Regards, Luke M *Remember to click "yes" i...

How do I track changes made to an Excel spreadsheet within a Word.
I established an Excel spreadsheet within a Word document by just using the Excel icon in Word and creating the spreadsheet. Now I find that the tracking feature in Word will not track the changes made to this spreadsheet, nor will the tracking tool in Excel. Can anyone help? Thanks. ...

"Difference From" custom calculation in Pivot tables
I have been unsuccessful in using the "Difference From" custom calculation in Pivot tables. When I use this custom calculation (I can successfully use the % of Total for example) I get #N/A. Also, I'm not sure what the Base Field and Base Item boxes represent. I notice in the Base Item box there is "Previous", "Next" and a series of numbers which I don't understand what they represent. If someone could straighten my out on how to use this feature or point me in the direction of some instructions that would take me thru this process I would rea...

need a refresher: text boxes on charts that use relational formulas?
I could have sworn that a long time ago, I set up one or more text boxes on a graph that had formulas in them, so the text that was showing would automatically change each month. I'm now using Win2000/XL2003, and not having much luck- I want to put my legend on the bottom, then a text box under it where I will show 3 values (one for each legend item) to provide some additional information on the graph. I have too many graphs to do this and have to update it all manually. What is the best approach to use, to link the contents of my text box (or similar) to the contents of a cell that on m...

Pivot Table Calculated Item #3
I am querying an external database to retrun a pivot table, then i am adding a calculated field that calculates Regular hours * Bill rate. to come up with total revenue. When it runs, the calculated amounts are 2, 3, 4 times more that what it should be. any ideas how i can get this calculation to return the right amounts. thanks Jerry H5 erry Excel stores hours as fractions of a day, so multiply Hours * 24 * Bill Rate Regards Roger Govier jerry wrote: > I am querying an external database to retrun a pivot table, then i am adding > a calculated field that calculates Regular...

XL2000: Charts don't print as displayed
Charts formatted and displayed [normal view] in 20% increments, but prints and print previews in 50% increments. Please help! Double click on the axis that keeps changing, and on the scale tab, clear the Auto checkboxes for the scale parameters. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ smasbell wrote: > Charts formatted and displayed [normal view] in 20% increments, but prints > and print previews in 50% increments. Please help! ...

IIf statement to change font to Bold
Access 2000. I have a report that shows [Bond], [Credits], [Debits] and [Balance]. The underlying query for [Blance] is =[Credits]-[Debits]. What I would like is for the fonts in the textbox [Balance] to change to BOLD when [Balance] exceeds the amount of the textbox [Bond] Example: [Bond] shows $1000.00, the [Balance] shows $1200.00. in this case the balance should be in bold font, otherwise it will be normal font. Is this possible? Thanks, Randy. <Randy> wrote: >Access 2000. I have a report that shows [Bond], [Credits], [Debits] and >[Balance]. The underlying ...

Pasted Pivot Table looks at old sheet
Hello all i have a quick question about pivot table pasting. i have a workbook where i am copying the sheet and making a new version for the next month. each time i do the pivot table on the new month sheet is looking at the old month sheet. the pivot table is on the same sheet where the data is that it looks at so each time i copy i want the new sheet to be totaly autonomous from the last month sheet. why does the pivot table not update to look at the new sheet? Hi Copying a Pivot Table will just make the PT use the same source data for it's Pivot Cache Right click...