Category color changes when changing values.

When I copy a chart I get two identical ones. When I change the values of one 
of the charts and sort the values, Excel changes the colors of the categories 
to a preset order, so that the color of the biggest customer in chart 1 is 
not the same as this same customer (let's say now on the third place) in 
chart 2.
Is there a way to prevent this?
0
JanSr (1)
7/11/2007 8:40:02 AM
excel.charting 18370 articles. 0 followers. Follow

0 Replies
513 Views

Similar Articles

[PageSpeed] 33

Reply:

Similar Artilces:

when I change page size the object does not resize to fit
when I change page size the basic object does not resize to fit . So I have to drag objects to fit That's correct. -- JoAnn Paules Microsoft MVP - Publisher How to ask a question http://support.microsoft.com/kb/555375 "basu" <basu@discussions.microsoft.com> wrote in message news:6C698998-F901-4F44-BD36-312844DC19BB@microsoft.com... > when I change page size the basic object does not resize to fit . > So I have to drag objects to fit This is how it is designed to work. Every program I use works the same way. Mike basu wrote: > when I change page size t...

Public Folder Permissions changed
We have a user who indicated his Public Folder sub-tree had it's default permissions set to Author. Are there any known issues in regards to a combination of client software/configurations that would overwrite the permissions for Defautlt and Anonymous access? Is there any kind of log file that would tell us when/who changed the permissions? We are running E2K3 in a 4+1 cluster. Thanks, John Oster OUHSC/IT John-O <JohnO@discussions.microsoft.com> wrote: >We have a user who indicated his Public Folder sub-tree had it's default >permissions set to Author. Are the...

Multiple colors in one stacked bar
I have to create the stacked bar chart based on following data : Bar# Width Kind 1 50 1 80 2 110 4 150 2 199 1 2 70 4 90 1 150 2 223 3 450 4 3 30 1 50 3 67 4 90 1 110 2 150 3 190 2 250 1 I need three bars, the "kind" column determine the colour of one section in current bar and the width determine width of this section. How to do it ? Maybe I have to reformat data ? -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Radoslaw Krzyzan , pl.communicat...

#Value! errors
I have experienced a problem that I am unable to find a rectification for. When my staff constantly use the space bar to delete an entered in error number and leave the cell blank (although there is a space in the cell) any cell which uses that cell within its formulation shows #Value! or #####. I am aware that they should not be using the space bar to delete numbers and the space within the cell is the reason for the other formulation errors. I guess my question is how do I format the cell so that only a number and nothing else can be entered? -- Field8585 --------------------------------...

Count of values within a cell?
Hi, I have a spreadsheet containing a row with data something like: A | B ____________ 1 | 1111 2 | 1112, 1113, 1114 3 | 4 | 1115 If I were to do a COUNTA(B:B) I would see a count of 3. What I'd *like* to find is a way to see a count of all numbers in that row (in this case, a count of 5). Any suggestions? Thanks! Jeff =SUMPRODUCT(--(B1:B100<>""),(LEN(B1:B100)-LEN(SUBSTITUTE(B1:B100,",",""))+1) ) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) <jeff.fry@gmail.com> wrote in message news:1163...

INSERTED table no holding exact float value
Hi All, I have a table A with a float column and a trigger to write to a log on inserts to table A. I am using the sql INSERTED table to get the value of the float column, and insert it into a varchar column in the log (cant be changed, its generic and used for multiple tables). I am having a weird issue where the value in the log gets rounded to the next integer in the audit table, it inserts correctly on Table A though. Is this a known issue? Is there a workaround? If not, what am i doing wrong? Thanks in advance, Ben *** Sent via Developersdex http://www.developersdex.co...

change default value "save message"
Hi all, I have a little problem. When i wanna save a mail message, de default filetype = rtf. I wanna change that to *.msg file. But i can't get that default! i have to change it every time manual! ...

Showing orders with a certain value of a bit field?
I've included a custom field on the order form. It's a bit field with the values YES and NO. The default value is NO. Our employees use this field to tell the system, if an order has been complete and is ready for invoicing. (We do not want to use the system possibility of completing an order). I've made a custom view of orders, where the view criteria is, that the value of this bit field is NO. And another view where the view criteria is, that the value is YES. However, when I select these views, I cannot see any orders. Could someone please explain, what I'm doing wr...

Please Help: compare values in two columns present in seperate tab
Hi All, How can I compare values in two columns (columns are in different tables) ? I also want to display the values that dont match in a seperate table. For eg: If values in Column1 from Table1 does not match Values in Column1 from Table2 then display those values in a seperate table Is there a way to do this? THanks in advance Under query types, there is one for unmatched data and one for matched. -- Milton Purdy ACCESS State of Arkansas "sam" wrote: > Hi All, > > > How can I compare values in two columns (columns are in differe...

Money Small Business 2004: Category does not show up in P&L Report
I use Microsoft Money Small Business 2004. I have created new sub-category Frenchise Tax under Business Taxes with supplying all requested information. like inclusion in Schedule C , type of Expence (Business ) I have assigned this category (Business Taxes : Franchise Tax ) to a transaction entry in my register. I run the reports->Business -> Profit and Loss statement, This entry does not show up in the report. However , when i assign this to other previously existed category like Federal Taxes , it does show up in report. Also, When I look up in category Screen, the trasaction indeed...

bulk change of all telephonenumbers
I have all telephonenumbers entered in the format +31555-555555 or 055-5555555 or 0555-555555 (or 06-55555555 for mobile phone). Now I want to start making phonecalls directly using this field, so I will have to delete the minus sign in it. What is an easy way to do that? There are over 500 contacts in the database each with 1, 2 or 3 phonenumbers. Is there an SQL command for that? Other suggestions? I found the answer in the SQL Serbver Management studio Help, Here's the syntax: UPDATE [_t_Computerhuys_MSCRM].[dbo].[ContactBase] SET [Telephone2] = '+31' + CONVERT(varch...

Business Alerts
Does anyone have a formula that works to alert (in GP 8.0) when "Pay code information" and/or when "Leave balances" have been changed? Thanks! David ...

Deafult Category Reports
Hi, How can I change the default category report from the reports view? thanks -- Magy You should able go to report manager in CRM, then selected the report - > Click edit. You can change the report category there. I don't know if this is what you are looking for. Hope this helps. Darren Liu Crowe Chizek and Company http://www.crowecrm.com On Mar 22, 3:17 am, Magy <M...@discussions.microsoft.com> wrote: > Hi, > > How can I change the default category report from the reports view? > > thanks > > -- > Magy If you are using crm v3, I don't th...

Printing Color-Coded Worksheet in Black & White Mode in Excel 2003
I work with farily complex Excel worksheets which require print outs as both hard copy and PDF. I normally keep the formatting as they are and select [Black and White] in [Page Setup] [Sheet], as this preserves the integrity of the financial model while printing out a clean copy for the enduser. However, this function basically converts everyting color-coded to black & white, including cell shading patterns; I normally accentuate certain important cells by shading them in black and using a white font color. While I want the output to be black & white, I do want to preserve this p...

how do i pick up the values ?
This is a multi-part message in MIME format. ------=_NextPart_000_01C7_01C33A40.6E296370 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi=20 I have this XML file, and i am not sure how do i read this xml file and = read it to an arraylist, for which i use to fire some SQL statements.=20 I want to be able to pick only xml attributes, say, which belong to = Section=3D"two-4" and put them into an arraylist and similar for the = rest of the Section attributes. i had got the code below working, till the time, i had to change the...

Restrict Changing Distribution Group Members
Hi, Is there any way to restrict which users can change (add/remove) who appears in a distribution group as members? Thanks, Trent. Hi Trent, It is all user that are able to modify group membership or just a subset because by default not everyone has this permission, apart from Domain admin, etc. Are these users with elevated privilidges on your domain? Take a look in the security tab on afew of your distro groups. Check which groups or users have read members and write members. You will need to turn on Advanced Features in ADUC, click the advanced security button in properties for ...

changing servers
I am wanting to purchase publisher for my office. We are preparing to upgrade to a new server in a few weeks and am worried that I will have to repurchase publisher when we switch over. Will my publisher program be available post changeover, or should I wait until after the change to buy the product? I am sure this isn't a very smart question but nonetheless I would like to know before I make my purchase. Im not exactly sure what you are asking, but Publisher is not network friendly...sure you can install Publisher on your local machine and save files to the server, but Publisher i...

Get values from blank cells
Hi, I have some width and height values in several columns with a lot of blank cells of sheet2. Like this: A B C blank blank 2*987 blank blank blank blank 4*500 blank 5*400 blank blank How can I get only the cells with values in column A of sheet1: A 5*400 4*500 2*987 Can this be done! Thank you so much What do you want to do if there are two values in a row? Average them? Add them? Both of these would work as long as if the values were numbers or blank. "canvas" <spyele123@gmail...

change the format of today(ctrl-;)
when I insert today using shortcut(ctrl-;), the format is yyyy-mm-dd by default. I want the format of yyyy.mm.dd. how can I change that? I use korean version of excel 2007. TIA. I think that Excel uses the Windows Short date format. You could try changing that short date format via the control panel. But remember this setting is used by all of windows. "news.microsoft.com" wrote: > > when I insert today using shortcut(ctrl-;), > the format is yyyy-mm-dd by default. > > I want the format of yyyy.mm.dd. > how can I change that? > > I use korean versi...

changing date format not working
After selecting a column and changing format to custom date yyyymmdd. The changes do not take place. Double Clicking in the individual cells afterwards bring up the desired results. Your dates were entered as Text, which isn't subject to Number Formats. You can coerce them back to XL dates by copying a blank cell, selecting your dates and choosing Edit/Paste Special, selecting the Values and Add radio buttons. Change the format to your desired one. In article <F3750B33-33C2-4C98-8696-E1F81FD2A796@microsoft.com>, "RickSenn" <RickSenn@discussions.microsoft.com...

Save Changes? #2
Sometimes, but not always, Excel asks if I want to save the current file, even though I've made no changes. Does anyone know why this occurs, and if there is a setting I can change to avoid the prompt unless actual changes are made? Thank you. Sprinks There are a number of functions that will update themselves when the workbook is opened, and this causes Excel to act as though the workbook has been changed. These functions include NOW() , TODAY(), ROW(), etc. See Volatile Functions in help for more info. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consult...

change HTML-mails to plain-text
My Problem is with incoming HTML-mails. If you open the mail and activate in the menue EDIT-edit (bearbeiten) e.g. Word or Excel will be opened, although in the menue TOOLS- Options-E-Mail-format Word is NOT activated as an editor. I want to stop this behaviour, becaus some PCs aren't able to print those mails or even see the full contents (the mails end with ">SPAN". Couldn't find another entry therefor in the www.) Aren't there any professionals reading this? silke <eilers@mucos.de> wrote: > My Problem is with incoming HTML-mails. If you open the &...

Hi all need to know how-to make protected areas within a document that won't change no matter what!
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel hi all, i am editing dozens of similar documents each week that all have a template like format but there is nothing to prevent me from messing it up while editing. for example, take this snippet: <h2>EVOCOTIVE TITLE FOR YOUTUBE MOVIE USE KEY PHRASE ONCE</h2> <center> <object width="425" height="344"><param name="movie" value="http://www.youtube.com/v/H2MpyODTLnY&hl=en&fs=1 <http://www.youtube.com/v/H2MpyODTLnY&hl=en&fs=1>"><...

two colored graph
i regularly create line graphs that include current data and projecte data. i can change the line colors but i would like to change th color of the grids so that the projected portion of the graph i different than the grids for the curent data. using the gradient fil option is not acceptable. any way??? thank -- jfillio ----------------------------------------------------------------------- jfillioe's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1623 View this thread: http://www.excelforum.com/showthread.php?threadid=27645 You could construct custom gridli...

Extract names from string based on value list
I have a list of productnames and a list of brandnames. I want to supply the productnames with an attribute "Brand". I am currently manually filtering the list of productnames based on "Contains... Brand" and adding the Brand to the product using copy paste, but this takes me too long and I can only match records one brand at a time. Can I make Excell search through the list of productnames and whenever it comes across a brandname within the string of a productname it will add it to the column next to it? One way Assume productnames running in A2 down A...