How to change bar color in numbers chart

Hey guys,


not that I am feeling stupid enough already but this one bothers me already way to long. My question is: how can I change the color of a single bar in a numbers chart? Whenever I try to change a color it adjust the new color to all bars from the dataset. But I just want to highlight single bars like different colors for competitors and my data etc. Is that possible and if so: how?


Thanks, guys! Appreciate it!

Posted on Apr 17, 2018 2:40 PM

Reply
4 replies

Apr 17, 2018 8:22 PM in response to mar85cus

It would be nice if you could change the color of each bar independently if you wanted to but it doesn't work that way in Numbers. One way to do it is to create a totally different chart, just like your original chart but with all the data set to 0 except the bars you want highlighted in each series. Remove things like legend, gridlines, etc., make the axis ranges identical for the two charts, make them the exact same size, then slide your "highlight" chart overtop of your other chart.


User uploaded file

Apr 18, 2018 5:26 AM in response to mar85cus

Here's a simple example of adding a data series, using the 'Charting Basics' template at File > New in your menu:


User uploaded file


Add a series (extra column) to the data table.


Click the chart, then 'Edit Data References' and expand the data area to include the new column.

User uploaded file


Change Chart Type to '2D Stacked Column'.


User uploaded file


Choose 'Plot Columns as Series' at lower left:


User uploaded file


You will now have one column with a different color. If you don't like the color that Numbers gives you then you can change it. First change the order of the series so you can select that one column.


User uploaded file


Then click that one column and change the color in the Style tab.


User uploaded file


The steps are similar for a horizontal bar chart.


SG

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to change bar color in numbers chart

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.