SOLVED

Scatter plot elements not showing on stacked bar chart

Copper Contributor

I have a Gantt chart with several milestones that should appear as scatter plot elements. Some of them are appearing and others are not, although there seem to be no differences in their formatting and no problems with the data references. I have confirmed that they are not hidden and that the x-axis minimum and maximum boundaries are wide enough to accommodate it. Any suggestions? Thank you. 

4 Replies

@NKPincombe 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

@Hans Vogelaar 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. 

best response confirmed by NKPincombe (Copper Contributor)
Solution

@NKPincombe 

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.
1 best response

Accepted Solutions
best response confirmed by NKPincombe (Copper Contributor)
Solution

@NKPincombe 

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.

View solution in original post