0

How to make the graph title change according to the selected data? I have created a graph using the subtotal command: =SUBTOTAL(9, D31:D558) When I filter the data to select a specific information, the graph will change automatically according to the subtotal. It works great.
Unfortunately the title of the graph will not work with filtering.

So I used the following formula: =IF(A5=214,"214 Dishwashers Map",(IF(A5=216,"216 Dishwashers Map","21 Dishwashers Map"))) and then set the graph title to cell A4, this will allow me to have the title change according to the information.

Unfortunately, the formula only works when I manually input the information in cell A5.

I was not able to have the formula look at the data after filtering and pick up the same information as in cell A5.

I tried to name (using name manager) the column and use that in the formula, but it did no work.

Any idea how to make the title more interactive without manual input?

Spreadsheet includes - several columns of data: First Column has location information - Alphanumeric Second Column has the first 3 digit numbers of the third column Third Column has the full identification numbers The rest of the columns have the actual data that are being added used in the Subtotal formula.

The second column is being filtered.

I am using the layout 5 from the Graph format. I also use the line graph.

Any help you can give me, it is very much appreciated. I have been trying to figure this out for the past 2 weeks.

Thank you in advance.

IS2017

Improve this question
8
  • Could you write how you are passing 214 and 216 to the Cell A5, any conditions behind this? And I'm sure that you have written the Formula in Cell A4 !!
    – Rajesh Sinha
    Dec 10, 2017 at 10:56
  • Yes the formula is in Cell A4 - I just type manually the selection that I need to show as a title in the chart in Cell A5.
    – IS2017
    Dec 11, 2017 at 4:34
  • Whether the selection is 21, 214 or 216. Thank you
    – IS2017
    Dec 11, 2017 at 4:34
  • I can suggest you two options. 1. Make a dropdown list with those 3 values in cell A5. 2. If these values are part of your database while filter, then use the Cell reference in A5 with filter.
    – Rajesh Sinha
    Dec 11, 2017 at 6:53
  • Filtering is the ideal thing than I would like to do. Unfortunately when I filter, the formula looks at visible and the not visible cells. I just need for the formula to look at the visible cells.
    – IS2017
    Dec 11, 2017 at 23:00

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .