Forum Discussion
Scatter plot elements not showing on stacked bar chart
Thanks. Many of the cells in M3:V10 contain formulas that may return "". But you cannot use "" in a scatter chart, so the scatter chart stops working correctly.
If you clear all the cells in M3:V10 whose formula returns 0, you should see the series.
But that is not an attractive option. Perhaps you should use a macro to populate only the cells you need.
HansVogelaar Here you are. There are 8 projects. The idea is to pull the milestones from separate workbooks using Get Data from Web and aggregate them into one 'Milestones' table. Then the Gantt chart table pulls the dates into either planned or completed milestones. The planned ones should populate as red circles and the completed ones as green circles. Most of the series are not showing and I cannot tell why. Thank you.
Thanks. Many of the cells in M3:V10 contain formulas that may return "". But you cannot use "" in a scatter chart, so the scatter chart stops working correctly.
If you clear all the cells in M3:V10 whose formula returns 0, you should see the series.
But that is not an attractive option. Perhaps you should use a macro to populate only the cells you need.
- Thank you, that solved the problem.