Solved

Excel Area Chart with a vertical line

Posted on 2013-06-07
6
1,534 Views
Last Modified: 2013-08-05
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
Comment
Question by:haslinger
  • 3
  • 3
6 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 39229198
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
 

Author Comment

by:haslinger
ID: 39229461
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
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 39256006
Hi

Could you send a dummy example?
0
ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

 

Author Comment

by:haslinger
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 49

Accepted Solution

by:
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

by:haslinger
ID: 39382768
Hi

That's the solution

thx a lot
guenter
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question