Pivot Chart: Show current value on X axis

[obiron]

Hi Guys,

I have a pitvot chart (showing as an unstacked line chart) with 5 data series on it. The Y axis is units and the X axis is Weeks. Some of the data is actual and some is forecasted. I would like to indicate on the chart the current week number. Ideally I would like to draw a black line vertically down the chart or change the background colour.

Does anyone know if this can be achieved. One possibility would be to add another data series which displays as a column chart and only populates for the given week, but as the size of the Y axis will change depending on what filters are applied, I am not sure how I would achieve this.

I would settle for making the current week number RED on the axis points.

Obiron

 

[Andrew Poulsom]

You could add a drop line to the one of the points that plots the current week.

Edit: Skip that, it's only possible fot the entire series.

 

[obiron]

Thanks for trying Andrew

Excel 2003 BTW