Solved

XL97: HowTo combine Line chart with Stock chart?

Posted on 1999-01-11
4
252 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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

696 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