ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating a High-Low-Close chart with multiple series? (https://www.excelbanter.com/excel-discussion-misc-queries/24489-creating-high-low-close-chart-multiple-series.html)

The Chad

Creating a High-Low-Close chart with multiple series?
 
Hi Everyone,

Im trying to create a High-Low-Close stock chart with 2 data series. Right
now, I can only get the chart to plot a single data series. Ive spent some
time playing with the chart options and doing some internet research but
still I havent found any answers.

My data looks something like this:
Stock A
Date High Low Close
6/30/2005 5 3 4
7/30/2005 10 6 8
8/30/2005 8 7 7.5
9/30/2005 9 2 5.5
10/30/2005 6 3 4.5
Stock B
Date High Low Close
6/30/2005 50 30 40
7/30/2005 100 60 80
8/30/2005 80 70 75
9/30/2005 90 20 55
10/30/2005 60 30 45

Any thoughts?

Thanks!
TheChad


All times are GMT +1. The time now is 06:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com