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: Forever_Isa
| Femeie 25 ani Giurgiu cauta Barbat 25 - 54 ani |
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 739
|
|
My chart has 3 columns for specific data as primary axes, then a stacked line with markers as secondary axis.
I want to add percentage trend (increase, decrease) on the 3 columns summed up, and percentage trend on the line.
1. I added the calculations of percentage trend in the table containing my data, then Select Data for my chart, and added the 2 percentage lines as stacked lines with markers, secondary axes.
Now I have 3 secondary lines, overlapping each other - main line and the 2 percentage lines added before.
2. I changed the line and marker colors of the 2 added lines to "No color", so I can see only the main secondary line.
3. Added labels and edited them in such a way that they don't overlap with other data, namely: - set labels for the secondary main line (one that has color) to appear as "Centered" and made markers for this main line with a size of 30. - set labels for the percentage line that is a trend to the secondary main line above, then set markers with a size of 30 and labels "Above" - set labels for the other percentage line to appear "Below", and made marker size of 45, but because they overlapped with primary columns, under Label Options - Alignment, I added 0,5 cm left margin
|
|
pus acum 8 luni |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2186
|
|
Problem with this is that if you made Custom colors for +/- trend, it might not work on other computers, even though the Custom formatting is saved within the Excel file.
_______________________________________
|
|
pus acum 8 luni |
|