Is there a way to have a chart dynamically update based upon filtering data?

Hi Spacebus,

You can find examples of interactive charts in the template Charting basics.

Here is a home-grown version constructed in Numbers 4.2 under MacOS Sierra. It works also with Numbers '09.

The table Chart Data pulls a row of data from the main table, depending upon the value entered in A2 (this could be a Pop-Up Menu).

Formula in B2 of Chart Data (and Fill right)

=INDEX(Weekly Data::B,MATCH($A2,Weekly Data::$A,0))

For a Category Chart such as this 2D Line, Chart Data has a Header Column and a Header Row.

Choose another week (4):

The title of your question mentions filtering. An interesting project for someone to investigate. Come on Numbers gurus! Does a filtered table plot only the visible rows?

Regards,

Ian.

"Come on Numbers gurus! Does a filtered table plot only the visible rows?"

Yes or No, depending on your expressed desires.

Expression is a matter of clicking a checkbox labeled "Hidden Data."

Regards,

Barry

Hi spacebus,

Thanks for the screenshot, but I am having trouble understanding the abbreviations and how they relate to your overall aim.

Here is a simplified document, using the Filter feature in Numbers. Avoid merged cells!

Identify those rows that you want to appear in the charts (graphs) by a formula in another column (G in this example).

Formula in G2 of the Master Table (and Fill Down)

=IF(AND(B2=Choose::B$1,C2=Choose::B$2),"Show","Hide")

Select the columns that you want as X and Y axes for each chart (graph) and insert those graphs.

Now apply a Filter to the Master Table

You can hide the column (G) that controls the Filter.

Thanks, Barry for the hint on how to include/exclude Hidden Data in a graph 🙂.

Regards,

Ian.

Hi spacebus,

Possibly. You will need to create a table to feed the chart. The table will need to collect only the data to be charted—category names to label the x axis and the associated value for each category.

The devil, of course, is in the details.

A screen shot of what you have and what you want might help plot a path from one to the other,

Regards,

Barry