How to create a chart based on color percentage?

  • Thread starter Thread starter joseandive
  • Start date Start date
J

joseandive

The data I am trying to compile for a pie chart is based on the color
percentage of the data. For example, I used three colors to identify my data
range. How can I base the pie chart not on the data, but on the colors used?
 
Colors do not have any cardinality attached to them. How large a wedge
should burnt orange be compared to lavendar or off-white?
What you can do is enter numeric values in the worksheet that correspond to
the colors and plot those values.
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu
 
Back
Top