Specify format in source data

  • Thread starter Thread starter lynxbci
  • Start date Start date
L

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
 
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/
_______
 
Back
Top