The Example Data to be plotted in an XY Scatter Chart
I have a question for you, though: have you ever encountered this problem? And if so, do you know what the root cause might be and how to overcome the problem? If so, please let me know in the comment section of the post. I have no clue why this is happening and therefore I do not have an explanation of what is going on, let alone a solution. Please be advised that today’s post is only a description of the issue. If you are trying to transfer the offset calculations into Named Formulas and use these Named Formulas as the source of you chart series, Excel does not always plot the data correctly. The recent articles Dynamic Storyboards in Excel and A practical Example for Dynamic Storyboards described a way how to plot several data series in one XY Scatter Chart by offsetting the data points.ĭuring the implementation of the workbooks coming with these articles, I stumbled across a weird Excel oddity: Please refer to the update at the end of the article or to Andy's message in the comment section. Update on Monday, August 3, 2020: The described issue is solved, thanks to Andy Pope. With Named Formulas as the Data Source of a Chart Series, Excel does not always plot the values correctly
0 kommentar(er)
