Last Value Projection when Using Right and Left Value Scales
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)…