Placing a dividing line in an excel chart.

[Chelsea7]

Hello there,

I have a question regarding charts in Excel 2010. I have data that updates weekly. I simply want to have a dividing line which separates between week 21 and week 22. The line is to always remain between week 21 and week 22 as the chart updates.

for example are the following weeks;

|
14 | 15 |16 | 17 | 18 | 19 | 20 | 21| 22

|
15 | 16 | 17 |18 | 19 |20 | 21 | 22 | 23

What is the best way to accomplish this?


Thanks

 

[SkipVought]

hi,

So is your chart x-axis a category axis or a numeric axis?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]