I've been having issues how to set up a combination of a bar chart and a combination chart. The way I currently have it laid out is that it shows the start and end date of an item (shown in Columns B and C) as a bar chart. I want to add scatter points to plot on the same chart of the "actual completion date" (shown in column D). For whatever reason, I've tried to set the data in column D as a scatter chart and secondary data, but it screws up the whole thing. I'm not entirely sure if my process is incorrect or why exactly it's not showing up how I'd like it to.
Bookmarks