How to make chart dynamic based on table of information?

(0) Share

Report

Posted on by olansgz

I'm brand new to google sheets. But how would I make a chart dynamic to this table here? I want to include a dropdown menu that has stuff like: " Last Year","Last 6 Months" and then filter it by category. I was thinking of maybe using =filter(), but wanted to get some input

I tried using =filter(), using a pivot table, but I'm just lost.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

RE: How to make chart dynamic based on table of information?

Hi olansgz,

Are you using the dynamics365 app?

If so, you can't include a dropdown menu to the chart directly, but you can add more views with different filters.

For date field, you can have the following filter to select as your needs:

The chart is shown based on current view, so you can select the view you need, then click show chart button:

Was this reply helpful? Yes No