FILTER function within Chart Data Range

Arts

Well-known Member
Joined
Sep 28, 2007
Messages
765
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi all

Is it possible within 365 to use the FILTER function within the Chart Data Range? The issue is as I select from the drop down value the range alters but from within the graph the range doesn't seem to adjust accordingly.

I did try to use # within the Chart Data Range aspect and no luck so wondered if this was firstly at all possible and if so what the correct syntax would be ?

How I entered was

1696429221745.png



Many thanks
 
If there isn't a cost element involved can only assume this would be the latest version available (on the slowest channel), thanks for the background info on versions!
 
Upvote 0

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
There's no cost difference. A lot of Enterprises choose the slower channels on the assumption that any feature bugs will have been ironed out by the time they get them released. Security updates still get released regularly but they only get new features twice a year. (ours is on an even slower release cycle than yours)
 
Upvote 0
Hard to imagine a firm that moves slower than mine 😄
 
Upvote 0

Forum statistics

Threads
1,215,087
Messages
6,123,050
Members
449,092
Latest member
ikke

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