Solved

# Excel Area Chart with a vertical line

Posted on 2013-06-07
1,395 Views
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
Question by:haslinger
• 3
• 3

LVL 48

Expert Comment

ID: 39229198
Pls refer to

Add a Vertical Line to a Column or Line Chart: Series Method

Add a Vertical Line to a Column or Line Chart: Error Bar Method

Add a Horizontal Line to a Column or Line Chart: Series Method

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

Regards
0

Author Comment

ID: 39229461

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

LVL 48

Expert Comment

ID: 39256006
Hi

Could you send a dummy example?
0

Author Comment

ID: 39262317
Hi

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

thx
z.xls
0

LVL 48

Accepted Solution

Rgonzo1971 earned 200 total points
ID: 39379664
Hi,

Is it what you are looking for
zVersion2.xls

see in data for the second serie

Regards
0

Author Closing Comment

ID: 39382768
Hi

That's the solution

thx a lot
guenter
0

## Featured Post

### Suggested Solutions

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity anâ€¦
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabilâ€¦
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.