Specify format in source data

[lynxbci]

can you specify format information in the source data. for example coul
you specify that a segment in a pie chart for sales of oranges shoul
always be orange, apples green etc et

 

[Jon Peltier]

In this post I show a macro that colors a series based on the series
name. It would not be a major effort to base the color instead on the X
value of a point.

Of course, if the fruits are always in the same order, just keep using a
copy of the same chart, or turn it into a custom chart type:

http://peltiertech.com/Excel/ChartsHowTo/CreateCustomTypes.html

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