numbers line chart interactive

Question

Level 1

8 points

numbers line chart interactive

Hi there :) hoping someone could help please with this?

I'm trying to set up something on Numbers for social media followers.

I like this current setup of the chart above the tables (pic attached) but I can't find out how to make the chart interactive? what I mean by that is I'm trying to make it so that when I click the arrows (like on an interactive chart), only the lines change to reflect the different social media type (Tiktok, Twitter, Insta).

MacBook Pro with Touch Bar

Posted on Jun 29, 2021 6:55 AM

Reply

Answer 1

Best reply

Yellowbox

Level 7

20,531 points

Jun 29, 2021 8:01 AM in response to s_pellegrino

Hi s_pellegrino,

The INDIRECT function is your friend.

From the Function Browser,

The INDIRECT function returns the contents of a cell or range referenced by an address specified as a string value.

If each social media type contains the same data in column A (Date) and column B (Goal), you can use another table to pull data from column C (Actual) of a chosen table.

I shortened the table names.

The single-cell table "Choose" is a Pop-Up Menu.

Formula in C2 of the "Data for Graph" table:

INDIRECT(Choose::A$1&":: "&ROW())

Choosing Twitter from the Pop-Up Menu:

Use the "Data for Graph" table to construct your graph. It will interactively show the values in column C.

Regards,

Ian.

Reply

Answer 2

s_pellegrino Author

Level 1

8 points

Jun 29, 2021 8:44 AM in response to Yellowbox

oh wow that's. wow!!! thank you Ian :D

really clever solution!

I'm- I don't understand how the 'Data for Graph' table is getting all the values from the other social media tables when I only reference the little 'Choose' table and didn't even reference the social media tables, but I'm over the moon 😆

Reply

Answer 3

Yellowbox

Level 7

20,531 points

Jun 29, 2021 5:15 PM in response to s_pellegrino

Yes, I'm surprised it works!

The formula in C2 of the "Data for Graph" table

INDIRECT(Choose::A$1&":: "&ROW())

should be

INDIRECT(Choose::A$1&":: "&"C"&ROW())

For some reason, it works without the &"C" part.

Puzzling.

Reply

numbers line chart interactive

Similar questions