Forum Discussion
Solved
Scatter chart plots wrongly if blank cells exist in input range
I am trying to make a general template to plot a Q-Q plot for upto 100 data points (if a reader is unaware of what a Q-Q plot is, in present context it doesn't matter, just take it as a simple X-Y Sc...
You may apply dynamic ranges using named formulas as
using them as data for chart series
Don't forget sheet name applying series values, like ='99 points'!PlotX
You may apply dynamic ranges using named formulas as
using them as data for chart series
Don't forget sheet name applying series values, like ='99 points'!PlotX
SergeiBaklan thanks! i get the idea and it seems a good solution.
Strangely though, in my version of Excel (2016), the named formula is automatically referring to the workbook name. Even when i open your (downloaded) solution workbook as it is, it shows workbook name instead of sheet name. Must be something to do with the excel version i guess.
But thanks, i get the line of the solution!
