Better color progression needed. . .

I am charting a 3D surface plot, but the colors provided in Excel (97) don't show a smooth progression eg light to dark or red to blue, and this gives a disjointed effect if the chart is reproduced in greyscale.  Are there any sample charts out there where I can import better colors

TI

Steve
0
2/26/2004 10:51:05 AM
excel.charting 18370 articles. 0 followers. Follow

2 Replies
337 Views

Similar Articles

[PageSpeed] 49

XL is rather limited when it comes to color sophistication.  It is 
limited to the 56 colors in its palette, though, it is possible to 
replace any of the 56 with others of your choice.

Your other option, I imagine, is to export the XL chart as a graphic 
image into the image editor of your choice and enhance the colors in 
there.  Of course, that means that if the chart changes...

-- 
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <F4702656-FA3E-42C6-979D-38A8753D9F5A@microsoft.com>, 
stevewblake@hotmail.com says...
> I am charting a 3D surface plot, but the colors provided in Excel (97) don't show a smooth progression eg light to dark or red to blue, and this gives a disjointed effect if the chart is reproduced in greyscale.  Are there any sample charts out there where I can import better colors?
> 
> TIA
> 
> Steve
> 
0
2/27/2004 1:21:42 AM
At least within the default palette, the user can select a range of 
colors that vary more gradually. You need to edit the legend to change 
these colors: select the legend (one single click), then select the 
legend key, that small colored square (another single click), then press 
Ctrl-1 (one) to format it. Pick colors that blend into each other more 
gradually.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Tushar Mehta wrote:

> XL is rather limited when it comes to color sophistication.  It is 
> limited to the 56 colors in its palette, though, it is possible to 
> replace any of the 56 with others of your choice.
> 
> Your other option, I imagine, is to export the XL chart as a graphic 
> image into the image editor of your choice and enhance the colors in 
> there.  Of course, that means that if the chart changes...
> 

0
jonxlmvpNO (4558)
2/27/2004 6:45:41 PM
Reply:

Similar Artilces:

no color shown only in preview
This is a multi-part message in MIME format. ------=_NextPart_000_0079_01C43BA2.8B7B2260 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Fill in color does display on worksheet only in preview WHY? Help ron ------=_NextPart_000_0079_01C43BA2.8B7B2260 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1&qu...

Definitely a Newbie--Need an example
I'm told VBS comes with MS OSes, and that if I had an example script of a vbs program, I could see how it works by double clicking on the file. Does someone have a simple program that I could try that on? Maybe something that simply prints some text or prints the results of a simple calculation. I'm using Win 7. -- Wayne Watson (Watson Adventures, Prop., Nevada City, CA) (121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time) Obz Site: 39� 15' 7" N, 121� 2' 32" W, 2700 feet Solid waste produced to gen...

Color Schemes #2
How do you export custom color schemes to Microsoft Office Frontpage 2003? You cannot. You do not really expect interoperability do you <shaking head in disbelief> -- ...

Aurgh, need help
I have 3 spreadsheets all which contain the similar data in this one single column. The three spreadsheets are being used by 3 different users. Each one is filling out different rows to that one column. What I need now is a formula to combine the information in that one column from their spreadsheets into a master column. I just want to keep the unique records though. Hope someone can help. regards, Spiro -- spirosu ------------------------------------------------------------------------ spirosu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7442 View t...

need more memory
Getting an error titled Mail "You need more memory or system resources. Close some windows and try again. OK" on my Win2k SP4 w/Outlook 2002 SP2 pc when I try to open the Mail icon in the Control Panel. Have tried copying mapi.dll and mapi32.dll files from an identical pc that works fine. Any suggestions would be appreciated. Thanks. ...

Can not receive Email.. Need Help
Hi all, Earlier this morning, my exchange server 2007 (hosted on SBS 2008) just stopped receiving external e-mail. We can send interoffice e-mails and we can send out e-mails to other locations fine, but we are unable to receive any e-mail. All internet connections are normal as well, and the port 25 is open on the firewall. The error from when we try to send an e-mail to the server is this: “This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed.” Earlier today I installed the anti-spam update from MS “Microsoft excha...

Strange Issues with Read Receipts Bouncing (Need expert help)
Hi, Currently migrating a company from NT 4 to Windows Server 2003, including an upgrade from Exchange 5.5 to Exchange 2003. The excistingDNS name space for Dns and mail is user@comany.com (old domain)The Dns name space for Dns and mail on the new Domain and AD Server and Exchange is user@company.local. The Dns namespace @company.com is registered on Internet but @company.local is purely for internal addresssing, We are busy with the Exchange Migration. We have setup custom contacts on Exchange 2003 viewable in address book for all users on 5.5 using user@company.com,also with an ad...

Office "hexagon" style color picker?
I'm not too familiar with color theory, but I'm trying to duplicate the Office "hexagon" style color picker. The one where you get the 6 sided picker with 127 (or is it 128?) colors all in the shape of hexagons. I've looked at codeguru and codeproject for samples, and there was one sample in the same type of thing, but its colors were completely different. A few questions... I can easily just copy the on screen image and use that, and then do a GetPixel() to get the color the user clicks on, but that leaves some unanswered implementation questions like how to figure out ...

Need to add another user to outlook
Hi, I am using the Outlook task manager on a pc that has multiple users all on the one pc profile. Can I set up Outlook to make folders (or the like) for separate users of the task manager and journal or are we stuck with just one assigned user of outlook? Many Thanks Use the mail applet in the control panel, with OL closed, to create a new Profile with new data file. This will be completely seperate to your existing data file "flynni" <flynni@discussions.microsoft.com> wrote in message news:D9114318-DEC1-4BEC-BEEF-65AA7BB64AE4@microsoft.com... > Hi, I am using the Ou...

Need to eliminate a Password change dialog box that appears when u
When a user goes to login to the exchange server VIA the web. When Entering in user/pass a message box appears stating that the password they are using is about to expire. You have 0 day's to change. Then it tell the user to go to Options to change the current password. How I do I eliminate this message? Also what caused this message to be displayed all of a sudden. Thanks for you time. Marcus On Wed, 13 Oct 2004 06:47:05 -0700, Marcus Feldmore <MarcusFeldmore@discussions.microsoft.com> wrote: >When a user goes to login to the exchange server VIA the web. When Entering &g...

Need help using MsgBox to learn Bangs & Dots
I have these things MyDb (data base name) tblA tblB Fields in tblA = Name, Location, Phone Fields in tblB = Date, Qty, Cost FormA with Sub_FormB The Question: How to write code to display Cost using bangs & dots? Assume FormA is open & displaying a record... and we double click on something... a field or a button or whatever... BUT we are not going to use "Me" so we can see how it all works... maybe something kinda like?? MsgBox code MyDb ! FormA ! Sub_FormB ! [Cost] 1 - Please show me the correct way to do the above. 2 - And... how would you do it using "Me&quo...

Font Color Conditional Formatting/Color Scaling
tWithin a matrix of data, I want to use two conditional formating/color scaling: one for the background color of the cell, the second for the font color corresponding to a different (but same size) data matrix. I know how to use the conditional formatting/color scaling for the background color--however would it be possible to have a different color scaling for the font color (and applied to one data matrix but referencing a separate data matrix)? Or even, can I at least use the conditional formatting/color scaling but changing the font color instead of the background cell col...

Need HELP with HTML!
Subject: Need html help for MicroSoft Publisher 2000 From: "Barbara" <photosbybarbara@yahoo.com> Sent: 10/9/2003 7:10:17 AM I just recently designed a web page in microsoft publisher 2000 and uploaded to server, only to find out that I have NO CONTROL over html coding in pages because when saved as web page it saved every page as an "image map!!" Why?! Where is the coding. I know a little about html and this is not it! I just assumed when saved as html it would be saved in html coding!! I don't want to start over with another web design program such ...

Need Help with Making Address Labels with Data Merge
Hi Anyone, I have done this before, but I downloaded the latest update to Office 2004. I have created my excel spreadsheets and cannot make data merge help me with address labels. I would be better off hand writing over 250 addresses on mailers as I have put in over 10 hours of time and am able to make address labels but 24 pages of labels only produces 8 addresses over and over again. Anyone with tips out there? Feel free to email me at melanie.m.hahn@gmail.com. The entire process has aggrevated my back and so I will now go lie down and perhaps some miracle will take place. Thank you f...

Help needed
is there anyway you can see what links to other workbooks are associated with the workbook you have open. The problem i am having is when i open the workbook in question a message appears and states "The workbook you opened contains automatic links to information in another workbook. do you want to update this workbook with changes made to the other workbook" Yes....... No. if i click No the workbook opens, however if i click Yes the workbook just hangs and i have to go into task manager to shut down the system. I can only assume that there is a problem with one of the links....

[ Help need to switch from Mac Entourage to PC Outlook ]
Hi Everyone :) I have to switch at work all my Entourage content to a PC. After reading the MS posts the only tip they give is to use an IMAP server to tranfer the emails but I got more than a GB of messages :S Any other tip that might help me? Got to export emails, contacts and calendar. Ty all for your help. Regards, Lady.- Hi, I have a similar need and have had similar luck finding an answer. Have you had any luck? Thanks, Jim >-----Original Message----- >Hi Everyone :) >I have to switch at work all my Entourage content to a PC. >After reading the MS posts the only tip t...

Match Text Color to Color in Picture
I need to match the color of some text to a color that is contained in a picture in the same document. I cannot find any help text, MSKB, or discussion group interaction on this. Any suggestions?? Thanks. Rick If you send the picture to me, I'd be willing to see if I can help. You may send it to jl dot paules at gmail dot com. -- JoAnn Paules MVP Microsoft [Publisher] "Rick Hamilton" <RickHamilton@discussions.microsoft.com> wrote in message news:16AAC4A4-8CF4-4544-8D65-3A7E557B46B5@microsoft.com... >I need to match the color of some text to a color that i...

Unable to Print Colored Text
Although print preview shows my colored font correctly, when it prints, it prints in black. My graphics and page color print correctly, however. I have researched this problem and found one instruction to go to the tools menu and unclick a color matching selection, but I can't find the tools menu to try this fix. I then researched that problem (no tools menu) and got nowhere. I am totally frustrated in trying to resolve this problem. I have Word 2007 and Windows 7. I have installed all available updates. Any help you can give me would be appreciated. Thanks. Maureen ...

Count by color using VBA in Microsoft Excel
I am having the following formula to count on the basis of colour. For example Total 12 cell out of which Red - 1, Yellow - 5 & Green - 6 so by using this formula this should give proper count as mentioned above. I need you assistance as i have never used macro using VBA in Microsoft Excel. Could you please guide me (Step by Step) how to run this macro in excel. Appreciate your kind assistance. Thanks in advance. Kamlesh Function CountByColor(InputRange As Range, ColorRange as Range) As Long Dim cl As Range, TempCount As Long, ColorIndex As Integer ColorIndex = ColorRange.Cell...

color catagories should not change all in series meetings
Color Categories: This feature is useless when dealing with meetings that are set in series. Say I want to tag a meeting to remind me to schedule a sub meeting and only have it affect the one meeting in the series when changing color instead it changes all in series. It needs to react as if each meeting was set-up as single events and not affect the other meetings in future as I have no assignments because the meeting has not taken place. "Mac" <Mac@discussions.microsoft.com> wrote in message news:3CD1734D-019A-46A4-93D0-00EAD89A8017@microsoft.com... > Co...

need help with offline address book
Exchange 2000 It seems our OFFLINE ADDRESS BOOK may have become corrupted. The original offline folder from the Exchange installation is showing in the the Outlook client [The "Choose Address Book" setting] however it has old data, not replicating. It is also missing the OAB Version 2 folder - it seems to be partially dead. I was able to create a new Offline Address Book under the Recipients folder and this did propagate to the OFFLINE ADDRESS BOOK folder under the Public Folders and created a new OAB Version 2 folder. As a test I manually entered the distinguished name of the n...

Formula to print a datum in color contingent on value.
I need a formula that will change the displayed color of a value based on amount. For example: under 200=yellow, over 200=red. Also, can I add input from a third column? For example: under 200 and Column D=No, then yellow. under 200 and column D=yes, then green. Try conditional formatting for the cells Click on /scroll over cells you need to format FORMAT>CONDITIONAL FORMATTING "Shadyhosta" wrote: > I need a formula that will change the displayed color of a value based on > amount. > For example: under 200=yellow, over 200=red. > Also, can I add input from a thi...

printing in color and black and white
I am using Publisher to create a church newsletter. I would like it to be in full color to convert to a PDF, but also to print it so that only some of the pages are in color. My copier rep was not much help on this one. -- alice ...

Header pane & ng name colors
Why are some of the headers red but the rest either dk grey (unread) or washed-out-grey (read)? Why are a couple of the names of newsgroups (not in the same account) red instead of dk grey? None of these "red" cases seem to have anything in common -- they're not just threads I've participated in, it's not all of the threads I've participated in, it's not all the newsgroups with recent traffic I have participated in, it's not even just ngs with recent traffic that I've been in at some point. It certainly isn't a filter that's gotten ...

I need help
I'm not that computer literate i want to know why i can't play any music that i have in my media player after i did everything i could to update and download. The message i am getting is. Can't play file, it does not support the CODEC that was used to compress the file. What can i do to get my music to play again? It was working before i have no idea what happened.... "Mary1965" <Mary1965@discussions.microsoft.com> wrote in message news:E2EF75C0-C535-4776-B30E-853E1BAD7A83@microsoft.com... > I'm not that computer literate i want to know why...