ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to create a chart based on color percentage? (https://www.excelbanter.com/charts-charting-excel/230331-how-create-chart-based-color-percentage.html)

joseandive

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?

Tushar Mehta[_4_]

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