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:
ElizaElizaiubi la Simpatie.ro
Femeie
23 ani
Satu Mare
cauta Barbat
23 - 53 ani
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] Change bar colors in a chart faster, using hotkey and mouse Moderat de TRaP, TonyTzu
Autor
Mesaj Pagini: 1
Mrrrr
AdMiN

Inregistrat: acum 17 ani
Postari: 2189
Say you have a chart with 40 vertical bars. You need to make 30 of them red and 10 green. Unfortunately in charts you can't select multiple bars at once (using a key combination; ie like CTRL+click works for multiple cells). What you need to do is:

1. Make all of them red first.
2. Select only one and change its color to green.
3. Select the next one and press F4.
4. And the next one, and so on until there are 10 green bars.

Pressing F4 makes the process a bit faster because otherwise you would have to click each bar and go to the ribbon and click "fill color" each time. This way you put both your hands and work, thus making the process faster and less annoying.

Source:


_______________________________________


pus acum 11 ani
   
Pagini: 1  

Mergi la