I need help with some charts in Excel.

[dave4578]

I am wondering if anyone here knows how to plot new data on top of a stock chart in Excel? I can make my stock charts but I don?t know how to take new data from the same time period and plot a new line over my original stock chart data. I know that this can be done because I have seen pictures of it in a book before. Does anyone know how to do this?

Thanks

 

[Bglad]

By chart you mean graph?

If so, you need to manually tell it which data to use in the graph setup. Then you there is a button to add a new series or something like that (sorry I'm not at my machine with Excel installed) adn you tell it where the second string of data to be graphed lies. You can do this as many times as you want.

 

[dave4578]

Okay, I'm starting to figure it out. Thanks Bglad. Do you know if it is possible to link two or more graphs together so that the plot area would be the same size? Right now I just put one graph under the other but I find that I have to change to font size around on the Y axis to get the plot size the same in both graphs so I can get the X axis on my charts to line up with each other. I am wondering if there is a way to get Excel to link the charts together automatically?

Thanks

 

[Bglad]

Hmmmm...

Idea 1 is turn off the auto format so it doesn't resize automatically depending on the breadth of the axis.

Idea 2 is make your first graph. Then copy and paste so you have an identical second copy of the graph in your worksheet. Then go into the settings of the second graph and change the data to what you want in the second graph.

Also, you don't have to change the font size, besides you would probably want the fonts to be the same. You can highlight any element in the graph, i.e. the whole graph boundary, the chart boundaries, the labels, etc. and resize them independently.

 

[dave4578]

PERFECT.

Thanks much Bglad.