Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 438
- Office Version
- 365
- Platform
- Windows
I have an x y chart with 10 series' with dynamic named ranges for the x and y coordinates (sample of one named range below)
Depending on the user the number of these ranges used is variable with the maximum being 10.
If there are less than 10 then the chart still plots the ones with no data as a 1 for the x and 0 for the y coordinates, which makes the scale of the graph unreadable.
I'm trying to find a way that if only 8 of the ranges are used then 9 and 10 do not appear on the chart at all
Example named range for range 2 - =IFERROR(OFFSET(Chart!$D$20,MATCH(2,Chart!$B$21:$B$5000,0),,COUNTIF(Chart!$B$21:$B$5000,2)),"")
Is there a way I can make this happen?
Thank you for any help.
Chart example using 8 ranges
Depending on the user the number of these ranges used is variable with the maximum being 10.
If there are less than 10 then the chart still plots the ones with no data as a 1 for the x and 0 for the y coordinates, which makes the scale of the graph unreadable.
I'm trying to find a way that if only 8 of the ranges are used then 9 and 10 do not appear on the chart at all
Example named range for range 2 - =IFERROR(OFFSET(Chart!$D$20,MATCH(2,Chart!$B$21:$B$5000,0),,COUNTIF(Chart!$B$21:$B$5000,2)),"")
Is there a way I can make this happen?
Thank you for any help.
Chart example using 8 ranges
