XL97: HowTo combine Line chart with Stock chart?

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.
skb7Asked:
Who is Participating?
 
bruintjeConnect With a Mentor Commented:
That was meant as an answer :O)
0
 
bruintjeCommented:
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
 
skb7Author Commented:
Thanks. Didn't EVEN think about that.
0
 
bruintjeCommented:
Ahh, Glad I could help :O)
As a market freak I had to find out myself..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.