Chart Question

littleleaguedad

New Member
Joined
Aug 20, 2024
Messages
1
Office Version
  1. 2021
Platform
  1. Windows
  2. MacOS
I have an Excel Scatter Chart. 2 data series.
I have 3 slicers hooked up to a NON-Pivot table table.
The chart changes data when I change the slicers.
a. I would like the chart title to change with the slicers value.

b. If I can't do "a", then I would like to have a cell value with the slicer value.

c. If I can't do that "b", I would like to set up a cell where the value is from the data. I have tried to do a vlookup on one year of the data to get the title but it only registers the first vlookup value whether it's visible or not. IE it's returning non-visible records. so how do I do a vlookup to exclude non-visible records.

I have no report connections with the slicers since it's not a pivot table.

I have read all of the google solutions and watched youtube videos and I'm not smart enough to figure out the previous answers from google, stackoverflow or this forum, etc. So yes, I'm asking a question that has already been asked.

I have seen the pivottable example for the titles going with columns but I can't connect my pivot table to the slicer after I have already connected the slicer to the non-pivot table data.

Any help would be appreciated.
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Forum statistics

Threads
1,223,374
Messages
6,171,717
Members
452,418
Latest member
kennettz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top