I have and want to represent actual sales data for the whole year 2018 and for Jan 2019 in a column chart. Apart from that, I want to represent 2019 targets for the whole year in the same chart. I have been trying to represent this data in a simple column chart, but as the same year (2019) represents Target as well as actual sales data, the graph is not showing up properly. There are zeroes showing up in the gas between the columns. Attached is a screen shot. Is there a way I can get rid of the zeroes and align the x-axis and the bars? Please guide.
