If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can a stock chart be combined with an line chart?
I would like to overlay a line chart on a stock chart. Is there a way to do
this? |
#2
|
|||
|
|||
Can a stock chart be combined with an line chart?
Stock Chart with Added Series
http://peltiertech.com/Excel/Charts/StockChartPlus.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "karenjoy511" wrote in message ... I would like to overlay a line chart on a stock chart. Is there a way to do this? |
#3
|
|||
|
|||
Can a stock chart be combined with an line chart?
Thank you for the link. I got stuck on the step where you select the added
series and convert it to a scatter plot. When I tried to do that, I got a message that said "some chart types cannot be combined with other chart types. select a different chart type." I tried to select each different kind of scatter plot type but none would work. I am using Excel 2007, if that makes a difference. can someone help me? "Jon Peltier" wrote: Stock Chart with Added Series http://peltiertech.com/Excel/Charts/StockChartPlus.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "karenjoy511" wrote in message ... I would like to overlay a line chart on a stock chart. Is there a way to do this? |
#4
|
|||
|
|||
Can a stock chart be combined with an line chart?
Excel 2007 doesn't realize you can combine a stock chart with another
chart type (the designers probably never used Excel for real work). You'll have to start from scratch. Make a chart with four line chart series (open, high. low, close in that order) and one XY series, with all series on the primary axis. On the middle chart tools tab, add high-low lines and up-down bars. This adds these features to the line chart series, effectively making it a stock type chart. Then format each line chart series to remove any lines and markers. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ aaf26lon wrote: Thank you for the link. I got stuck on the step where you select the added series and convert it to a scatter plot. When I tried to do that, I got a message that said "some chart types cannot be combined with other chart types. select a different chart type." I tried to select each different kind of scatter plot type but none would work. I am using Excel 2007, if that makes a difference. can someone help me? "Jon Peltier" wrote: Stock Chart with Added Series http://peltiertech.com/Excel/Charts/StockChartPlus.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "karenjoy511" wrote in message ... I would like to overlay a line chart on a stock chart. Is there a way to do this? |
Thread Tools | |
Display Modes | |
|
|