Forum Discussion
Formatting for Animated Bar Chart
Hello,
I am trying to figure out a couple things for this Animated Bar Race visual.
1) I can't figure out where to navigate to format the text for the bar chart. I'd like for it to be WHITE since all the bars are different colors. I've gone to every menu item in formatting and am not figuring it out. What am I missing?
2) Not as much a big deal, but I'm trying to do a Top N filter for the Top 2 values. What is the appropriate way to filter so that there are 2 bars per year? In this case, there are 2 different leagues within Major League Baseball. I would like to display top performers from both leagues for each year where applicable.
3) Similar to my first question, is there a way to format for just one color on the bars every year?
I have attached a screenshot, but appears I can't attach the the underlying data (.xslx or .csv)
| Year | League | Player | SO |
| 2023 | NL | Spencer Strider (ATL) | 245 |
| 2022 | NL | Corbin Burnes (MIL) | 243 |
| 2021 | NL | Zack Wheeler (PHI) | 247 |
| 2020 | NL | Jacob deGrom (NYM) | 104 |
| 2019 | NL | Jacob deGrom (NYM) | 255 |
| 2018 | NL | Max Scherzer (WSN) | 300 |
| 2017 | NL | Max Scherzer (WSN) | 268 |
| 2016 | NL | Max Scherzer (WSN) | 284 |
| 2015 | NL | Clayton Kershaw* (LAD) | 301 |
| 2023 | AL | Kevin Gausman (TOR) | 207 |
| 2022 | AL | Gerrit Cole (NYY) | 257 |
| 2021 | AL | Robbie Ray* (TOR) | 248 |
| 2020 | AL | Shane Bieber (CLE) | 122 |
| 2019 | AL | Gerrit Cole (HOU) | 326 |
| 2018 | AL | Justin Verlander (HOU) | 290 |
| 2017 | AL | Chris Sale* (BOS) | 308 |
| 2016 | AL | Justin Verlander (DET) | 254 |
| 2015 | AL | Chris Sale* (CHW) | 274 |
| 2014 | AL | David Price* (2TM) | 271 |
| 2013 | AL | Yu Darvish (TEX) | 277 |
1 Reply
freginierSolution Sage
Hi there!
- For your first question, you have to go into data labels (when you are clicking your visual)-> value -> select the color you want, I will add a screeenshot.
- For your second question, I am not sure.
- For your third question, yes! If you go to the top of the data labels section, you will see "Apply settings to", you can choose the series/bars that you to apply colors to.
Hope this helps!
Zoe 😁