I got the following graph (in purple):

enter image description here

I want to add the dotted forecasting line.
It's a cell value, but not referenced to the point on the X-Axis (Oktober 13).

I'm a bit lost as to how I could accomplish it. Anyone got an idea?

  • 1
    From what I understand you are asking; unless the value is tied to the axis for October, all you can do is use line art to place it. Alternately, you could place your forecast values in cells which would allow you to add a second series for a forecast line. – CharlieRB Oct 17 '13 at 11:48

No problem. Your chart needs two series, one for your actual data (solid line) and one for your projected data (dashed line). For your second series, just make sure it plots beneath your primary (or you can use #N/A for the non-plotting values).

Here's a sample:

Second Series

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.