Hello,
I have data for sales for each quarter shown in a pivot chart. However, for the current quarter, there are only 2 months worth of sales data. Is there a way to show in my chart the current quarter sales, with an additional portion above that bar (in a different color) that shows the projection for the quarter? Please see attached file.

Projection.xlsx

Ideas?

Thanks!