software

I was wondering if there is any way to display the (more colors) color wheel
from Excel. Currenly I only get the block of 40 colors. Please advise.

jdc

You can't, not in current Excel.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jdcquot; gt; wrote in message
...
gt; I was wondering if there is any way to display the (more colors) color
wheel
gt; from Excel. Currenly I only get the block of 40 colors. Please advise.
gt;
gt; jdc
On Sat, 22 Apr 2006 17:36:18 0100, quot;Bob Phillipsquot;
gt; wrote:

gt;You can't, not in current Excel.

Actually, you CAN, but you can only change one of the existing 56
colours in the workbook (including the 16 chart colours below the main
40 in the Format Cells dialog), not introduce more than 56 colours.

You can't do it through the Format -gt; Cells dialog, but you can go to
Tools-gt; Options -gt; Color, select the colour that you want to change,
and select [Modify]. This doesn't brng up the wheel, but rather a tab
dialog which allows you to set the colour in question to any RGB
value.

This will affect the current workbook only.

gt;
gt;(remove nothere from email address if mailing direct)
gt;
gt;quot;jdcquot; gt; wrote in message
...
gt;gt; I was wondering if there is any way to display the (more colors) color
gt;wheel
gt;gt; from Excel. Currenly I only get the block of 40 colors. Please advise.
gt;gt;
gt;gt; jdc
gt;---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *


quot;Hank Scorpioquot; gt; wrote in message
...
gt; On Sat, 22 Apr 2006 17:36:18 0100, quot;Bob Phillipsquot;
gt; gt; wrote:
gt;
gt; gt;You can't, not in current Excel.
gt;
gt; Actually, you CAN, but you can only change one of the existing 56
gt; colours in the workbook (including the 16 chart colours below the main
gt; 40 in the Format Cells dialog), not introduce more than 56 colours.

Therefore you can't.
On Sat, 22 Apr 2006 22:44:46 0100, quot;Bob Phillipsquot;
gt; wrote:

gt;
gt;quot;Hank Scorpioquot; gt; wrote in message
.. .
gt;gt; On Sat, 22 Apr 2006 17:36:18 0100, quot;Bob Phillipsquot;
gt;gt; gt; wrote:
gt;gt;
gt;gt; gt;You can't, not in current Excel.
gt;gt;
gt;gt; Actually, you CAN, but you can only change one of the existing 56
gt;gt; colours in the workbook (including the 16 chart colours below the main
gt;gt; 40 in the Format Cells dialog), not introduce more than 56 colours.
gt;
gt;Therefore you can't.

Bob, the OP asked quot;I was wondering if there is any way to display the
(more colors) color wheelquot;, not quot;I was wondering whether there was any
way to increase the number of coloursquot;.

Granted their statement quot;Currenly I only get the block of 40 colorsquot;
might have thrown some ambiguity in, but as to whether or not you can
display if not the colour wheel but a dialog with corresponding
functionality, yes, you can.

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *

On Sun, 23 Apr 2006 08:00:46 1000, Hank Scorpio
gt; wrote:

gt;Bob, the OP asked quot;I was wondering if there is any way to display the
gt;(more colors) color wheelquot;, not quot;I was wondering whether there was any
gt;way to increase the number of coloursquot;.

I should have also mentioned that the button which launches the same
dialog as the one launched through Tools -gt; Options -gt; Colors -gt;
Modify in Excel is labelled quot;More Colorsquot; in Word. I therefore thought
it not unresonable to guess that that was what s/he was actually
after.

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *