Add NewSeries problem ?

Hi beautiful people,
1- Open enclosed file, and see that everything is okey in stock chart. (Look there is a orange line there)
2- Delete that stock chart and then run following macro.

Please Login or Register  to view this content.

Why you can not see WEIGHTED AVERAGE series (orange series) after running that macro ?

Please Login or Register  to view this content.

Hi Andy, good to see you again
Thanks for this support. Solved.

I have another question regarding this chart.
If you carefully look that stock chart, weighted average line does not go across middle of the candles... Any idea ?

The stock charts don't like doing anything beyond the designated task. You will see that changing the weighted average value distorts the candle.

You may have to build the chart your self using a mixture of column, stacked column, error bars and lines.

Ok...
Lets jump my similar question...
Please help my similar question...
http://www.excelforum.com/excel-char...hlc-chart.html

Well I guess that will have the same answer then

You may have to build the chart your self using a mixture of column, stacked column, error bars and lines.

I couldnt solved that issue myself
I believe that you are expert of this kind of chart

So what did you try?

I tried combined charts.
I am very well with simple combined charts.
But combined stock charts are very diffucult for me...

Create chart on range $J$1:$P$11

Move series 2 to 6 to secondary axis
change series 5 and 6 to line chart

to series 5 add error bars and set to Plus using custom range $Q$2:$Q$11

Only problem is the high/low line appears above the open/close box.

First of all thanks for your great effort.

Formula in the P2 cell must be =G2 instead of =E2 as far as I understand...

If this issue so diffucult, I am planning to create a new chart for average series,then making this chart's plot area transparant then put new chart above the old chart...

Yes, it should reference G2 if you want to use the weighted average value.

Although that does not appear to be center of Open/Close box, which is what I thought you wanted.
=C2+((F2-C2)/2)

Hi Andy,
Enclosed file had been created by you.
First of all thanks for your great job.
Enclosed file includes a stock chart which includes average series.
As you can see enclosed file you made some calculations (Pad, PosOpen, NegOpen, High Err).
My question is if it is possible to create average series stock chart without making any calculation.

In other words if it is possible to create average series stock chart using only following data and no calculation.
Date, VOLUME, OPEN, HIGH, LOW, CLOSE, Average

Best regards

No, as the pad series makes the columns float.