Forum Discussion
How do I create a chart with an or filter
I do not understand your chart. The colors go across, what do the combo-colors that go down represent? Also, based on the marking you have, what percent does each color have that would be represented by the pie chart?
I will try to explain better- I need to do a count if on each color on a pivot table for each color and unify all these sums of colors. The total will be the amount of Y I have
I do not understand the need for a pivot table for such a small amount of information. You originally requested a pie chart with percentages. My first answer met that requirement so please explain.
Hi, eventually I want to have the relative amount per color (sum if per color) that has Y in this pie (count if)
Amount/color Blue Red Green 5 Y Y 20 Y 6 Y sum 31 Count if 1 2 1 sum if blue 5 0 0 sum if red 0 25 0 sum if green 0 0 6 Hi,
In my actual charts I have something like 5 categories (which are colors here) and 50 rows. The amount is a number that represents time, so my goal is to know how much time we invested per category aka color
Thanks,
Moran