Hi,
I am trying to find a way of identifying the colours used as defaults for
series in a given Excel 2007 theme. However, unlike previous versions of
Excel, if you select a series and the choose a fill (say solid fill), it does
not show you the colour swatch that corresponds to the defualt colour (if you
haven't already changed it) - and, indeed, if you cycle through series, it
will show you the last colour you slected as the first pick for that
series... I would like to be able to match elements in a chart to colours
used for previous series and do not necessarily want to have to select the
colours for each series first. Ideally, I would also like to be able to
determine the rgb value for a given default colour in a theme but perhapsthat
is asking too much.
Any suggestions, as always, gratefully received.
Best wishes, Boris.

not show you the colour swatch that corresponds to the defualt colour

If it's any consolation, this bothers me as well. Unfortunately I have not
played around enough with it to be able to help.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Boris" wrote in message
...
Hi,
I am trying to find a way of identifying the colours used as defaults for
series in a given Excel 2007 theme. However, unlike previous versions of
Excel, if you select a series and the choose a fill (say solid fill), it
does
not show you the colour swatch that corresponds to the defualt colour (if
you
haven't already changed it) - and, indeed, if you cycle through series, it
will show you the last colour you slected as the first pick for that
series... I would like to be able to match elements in a chart to colours
used for previous series and do not necessarily want to have to select the
colours for each series first. Ideally, I would also like to be able to
determine the rgb value for a given default colour in a theme but
perhapsthat
is asking too much.
Any suggestions, as always, gratefully received.
Best wishes, Boris.

Thanks for your response, Jon. Should you come across a work around...
ploease do let me know!
Best wishes, Boris.

"Jon Peltier" wrote:

not show you the colour swatch that corresponds to the defualt colour

If it's any consolation, this bothers me as well. Unfortunately I have not
played around enough with it to be able to help.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Boris" wrote in message
...
Hi,
I am trying to find a way of identifying the colours used as defaults for
series in a given Excel 2007 theme. However, unlike previous versions of
Excel, if you select a series and the choose a fill (say solid fill), it
does
not show you the colour swatch that corresponds to the defualt colour (if
you
haven't already changed it) - and, indeed, if you cycle through series, it
will show you the last colour you slected as the first pick for that
series... I would like to be able to match elements in a chart to colours
used for previous series and do not necessarily want to have to select the
colours for each series first. Ideally, I would also like to be able to
determine the rgb value for a given default colour in a theme but
perhapsthat
is asking too much.
Any suggestions, as always, gratefully received.
Best wishes, Boris.

Thanks for your response, Jon. Should you come across a work around... please
do let me know!
Best wishes, Boris.

"Jon Peltier" wrote:

not show you the colour swatch that corresponds to the defualt colour

If it's any consolation, this bothers me as well. Unfortunately I have not
played around enough with it to be able to help.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Boris" wrote in message
...
Hi,
I am trying to find a way of identifying the colours used as defaults for
series in a given Excel 2007 theme. However, unlike previous versions of
Excel, if you select a series and the choose a fill (say solid fill), it
does
not show you the colour swatch that corresponds to the defualt colour (if
you
haven't already changed it) - and, indeed, if you cycle through series, it
will show you the last colour you slected as the first pick for that
series... I would like to be able to match elements in a chart to colours
used for previous series and do not necessarily want to have to select the
colours for each series first. Ideally, I would also like to be able to
determine the rgb value for a given default colour in a theme but
perhapsthat
is asking too much.
Any suggestions, as always, gratefully received.
Best wishes, Boris.