How to create a chart based on color percentage?
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? |
How to create a chart based on color percentage?
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 "joseandive" wrote: 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? |
All times are GMT +1. The time now is 02:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com