My colleagues also want me to keep the original data.
#EXCEL PIVOT CHART LEGEND CONTENT INSTALL#
I didn´t manage to do those things with the calculated field of the pivot table and I am not allowed to install power pivot on the computer. For this reasons importDate table and source table do not have the same size. and the most difficult : display two lines of data when there are two transactions on the same line (it is what happened when the product goes through hub 2 (otherwise I can not analyze the hub transit for each hub and it is one of the most important thing add one column with sold/available quantities do some operations on the quantities (their amount is given for one day of the runtime, I need the amount on the whole runtime) cut the runtime in two parts so that we can decide on which period we want the results to be displayed Yes, it would have been much easier to create the pivot chart from the first table but I need to work a bit on the data before being able to make understandable charts. Thank you very much in advance for any idea ! I was thinking that maybe there is an easier solution I did not think about. Modification and excel crashes down in half of the cases. It takes a looooot of time for every single I already tried to synchronize the length of the table with an other database to avoid having empty cells but this is done with a macro which works very well with 100 lines but not well with more than 200 lines. I can not change every graph every time.ĭo you have an idea ? It would be great :) If I do it in the filter and then add new data which generate new legend fields, those are not integrated in the graph because the previous filter is still active. Is there a way to hide those fields without doing it manually in the filter ? When the pivot charts are done, some legend fields display (blank) or #value! because some of the cells are still empty. The advantage is that I can synchronize all the different charts on a same criteria.
![excel pivot chart legend content excel pivot chart legend content](https://contexturesblog.com/wp-content/uploads/2019/11/pivotchartcompareyears01b_thumb.jpg)
I generate many pivot charts automatically from a 79 000 lines table which is the results of calculations in other sheets.