Solved

XL97: HowTo combine Line chart with Stock chart?

Posted on 1999-01-11
4
251 Views
Last Modified: 2012-06-21
XL97: How do you add a line chart to a stock chart? Another approach is to create a stock chart using HiLowlines with the open and close as xlMarkerStyleDash but adding another series without interfering with the HiLowLines does not seem possible.
0
Comment
Question by:skb7
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 44

Expert Comment

by:bruintje
ID: 1615554
Hi skb7,

You mean something like a openhilowclose chart and some line chart for a average, within the same picture?

If that's the case use the feature of adding a second y-axis to the chart and putting this y-axis as the y-axis for your line chart.

If you have further questions just ask, it's simpler once you've figured out how to do it.

:O)Bruintje.
0
 
LVL 44

Accepted Solution

by:
bruintje earned 150 total points
ID: 1615555
That was meant as an answer :O)
0
 

Author Comment

by:skb7
ID: 1615556
Thanks. Didn't EVEN think about that.
0
 
LVL 44

Expert Comment

by:bruintje
ID: 1615557
Ahh, Glad I could help :O)
As a market freak I had to find out myself..
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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
compare column in an Excel spreadsheet. 1 43
Tricky shapes formula part 2 4 21
Pull Phone Number out of Cell 3 12
Overwriting Named Ranges 13 31
Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

726 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