Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Grouping the same colored bars in a bar graph

I am making a bar graph with three different data sets. When I make the graph, my three data sets are spaced out and mixed in together. How do I group the same colored bars together?

User uploaded file

MacBook Pro (Retina, 13-inch, Late 2013), iOS 8.3

Posted on May 21, 2015 12:25 PM

Reply
Question marked as Best reply

Posted on May 21, 2015 1:35 PM

The only way I can come up with is to make three separate charts.


It's not too hard either


Here is the table I used:

User uploaded file

The first row and column are headers


select the first row of data (cells B2 thru G2)


now add a bar chart from the Charts menu

Format as needed


hold the option key then click and hold on the chart, then drag (this will duplicate the chart)

Now click the "Edit Data References" button below the chart

click in the blue, shaded region of the table and drag down one row

repeat for the last series


User uploaded file

User uploaded file

User uploaded file


now you can click the chart and then any of the colored bar and use the Style Formatter for the selected series to change the color and shading type:


User uploaded file

2 replies
Question marked as Best reply

May 21, 2015 1:35 PM in response to elle_95

The only way I can come up with is to make three separate charts.


It's not too hard either


Here is the table I used:

User uploaded file

The first row and column are headers


select the first row of data (cells B2 thru G2)


now add a bar chart from the Charts menu

Format as needed


hold the option key then click and hold on the chart, then drag (this will duplicate the chart)

Now click the "Edit Data References" button below the chart

click in the blue, shaded region of the table and drag down one row

repeat for the last series


User uploaded file

User uploaded file

User uploaded file


now you can click the chart and then any of the colored bar and use the Style Formatter for the selected series to change the color and shading type:


User uploaded file

Grouping the same colored bars in a bar graph

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