• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2389
  • Last Modified:

Excel Area Chart with a vertical line

Hello Experts

Is it possible to have a vertical line in an excel area chart?
I have the days on the x-axis and 3 types of data in the y-axis.
Now I want to show the actual day with a vertical line in the diagram.

Thx
guenter
0
haslinger
Asked:
haslinger
  • 3
  • 3
1 Solution
 
Rgonzo1971Commented:
Pls refer to

Add a Vertical Line to a Column or Line Chart: Series Method
http://peltiertech.com/Excel/Charts/AddLineVertSeries.html

Add a Vertical Line to a Column or Line Chart: Error Bar Method
http://peltiertech.com/Excel/Charts/AddLineVertErrBar.html

Add a Horizontal Line to a Column or Line Chart: Series Method
http://peltiertech.com/Excel/Charts/AddLineHorzSeries.html

Combining Different Chart Types into a Single Excel Chart
http://peltiertech.com/Excel/Charts/ComboCharts.html

Regards
0
 
haslingerAuthor Commented:
Thx for the fast answer, maybe your last link

Combining Different Chart Types into a Single Excel Chart
http://peltiertech.com/Excel/Charts/ComboCharts.html

can solve my problem.

The first 3 links won't because I use a "Stacked Area" chart,
and the links describe Columnor Line charts.

regard
guenter
0
 
Rgonzo1971Commented:
Hi

Could you send a dummy example?
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
haslingerAuthor Commented:
Hi

See the attached example.
I want to insert the "vertical line" to mark the current day e.g.

thx
z.xls
0
 
Rgonzo1971Commented:
Hi,

Is it what you are looking for
zVersion2.xls

see in data for the second serie

Regards
0
 
haslingerAuthor Commented:
Hi

That's the solution

thx a lot
guenter
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now