Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Jasmmyne la Simpatie.ro
 | Femeie
22 ani
Bucuresti
cauta Barbat
22 - 34 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 748
|
|
As far as I understand this cannot be done if you do a PivotTable Chart (select pivot table values and Insert - Chart / or insert blank chart, then select PivotTable as data).
You have to do a normal chart, then add series one by one to it, selecting each column. This way your chart will preserve its formatting if you select for example a different year.
However, if you select multiple years and you chose the year as column in your Pivot, then it will not sum up the values in multiple years, nor will it show them as additional series on your chart. See example below.
Say you have 2017, formatting correct, selecting 2018 the formatting will remain correct, the data is calculated correctly, 2019 the same, all good.
Once you select 2017 and 2018 in your slicer (or other year combinations), the data will only show for the first year.
So in order to sum up the data you need to add year as filter instead of column (or not add them at all, as slicers work anyway).
If the percentages are now incorrect (summing up multiple years might lead to wrong percentage between Pivot columns), you must remove the existing percentage field from your values, then add a calculated field.
See how it's done here:
Modificat de TRaP (acum 4 ani)
|
|
| pus acum 4 ani |
|