I'm looking to display company sales against a monthly goal with all 12 months showing in the chart. The sales are pulled from a SQL table and the goals are from an Excel workbook, with the two linked by "Effective Date." Since there haven't been sales in the remaining months of the year, I haven't been able to get those months to show in my charts or tables, thus I can't see the remaining goals to be hit.
I'd appreciate any insight on this. Thanks!
DId you try making excel data source as the primary data source and SQL table secondary?