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

Creating a graph using criteria from drop-down list

Hey all,

I am working with a large table containing indicators for countries; countries are listed in the first column and indicators are subsequent columns.

Since I have a lot of countries, it gets messy to display all countries on the same chart. So I created a column indicating each country's geographical region.

I would now like to have a graph that would display an indicator but only for the countries of a single geographical region I would choose from a drop-down list.

Is this possible? I haven't quite been able to find a way to do this so far and would very much appreciate a helping hand!

Thanks in advance!

~K.

Posted on Mar 18, 2018 3:50 AM

Best reply

Yellowbox

Level 7

20,383 points

Posted on Mar 19, 2018 10:41 AM

Hi K,

OK, let's forget my first suggestion. A filter will do it. Here is the unfiltered table with all countries and regions on the chart. Your table is bigger, and the chart will be even more of a mess!

Now apply a filter from the menu on the column label B

To see the whole table again, use the Filter panel on the right of the window and delete the filter rule.

Regards,

Ian.

View in context

5 replies

There are no replies.

Creating a graph using criteria from drop-down list

Welcome to Apple Support Community

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

Learn more Sign up