Vertical Line / Marker Anchored Into Chart

[Russ At Index]

Morning ,

I have a simple column chart which has week number along the horizontal axis and total values in £'s for the corresponding
week on the vertical axis.
I would ( or rather my boss would like !) an anchored vertical line placing at any given week number , for example a vertical line
linked to week 10 .
I have used the insert shape option , but to be honest its not great .... any advice would be as always appreciated .

Stay safe & sane ,

Russ.

 

[NdNoviceHlp]

Hi Russ. You need to add a "dummy" series to add the vertical line within a combination chart. See Jon's site at the link below. HTH. Dave

Roll Your Own Excel Combination Charts

Skip the built-in custom charts, and design your own combination charts in Excel.

peltiertech.com

 

[Russ At Index]

Hi Nd ,

Thanks for the link to Jon's excellent site .

Russ.

 

[NdNoviceHlp]

You are welcome. Thanks for posting your outcome. Dave

 

[Russ At Index]

Hi ,

Following on from my previous posting , i have another quandary that has landed on my desk .

Same question really , involving a vertical line , but this is into a pivot chart with a secondary axis included

My data is sales by week number vs customer complaints.

Any ideas ... ? ...

Many thanks

Russ.