Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

XL97: HowTo combine Line chart with Stock chart?

Posted on 1999-01-11
4
Medium Priority
?
255 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
  • 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 600 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

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 …
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

580 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