Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2204
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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