I have a chart that summarizes sales performance by month using a grouped vertical bar chart. The vertical bars represent units sold, sales dollars, and sales dollar margin. The margin is represented in dollars. My problem is this:
If I only use the left scale, the regression projection for the current period (last value) is represented on all 3 bars for the current month. But, if I add a right scale so that the left scale measures units and the right scale measures dollars, only the unit bar value is projected for the month, while the sales dollars and sales dollar margin values are not projected and only show their actual values (summations) through the latest day in the month that actual data has been collected.
Has anyone run into this issue and, am I doing something wrong? Or is this a bug?
Thank you in advance for any insights.