How to create a chart based on color percentage?

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?
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Doughnut Chart linked with the slicer in the pivot table 0
Printing from Word my Inserted Pictures colors are dull and lack color 0
Filtered view of Visio Chart 0
Creating Network Diagram using a Chart SW integration 0
How to create a bubble chart with more than 2 variables. 0
Creating a Chart on form from selected data in query. 0
Ways to create a budget chart for money managment 1

Top