I have a broken line graph with two sets of data.
Data set 1 I have monthly data
Data set 2 I have annual data
The X-axis displays months.
The y- axes are working fine, however data set 2 is being displayed as dots, is there a way to have excel draw lines between the dots?
Data set 1 I have monthly data
Data set 2 I have annual data
The X-axis displays months.
The y- axes are working fine, however data set 2 is being displayed as dots, is there a way to have excel draw lines between the dots?