How can i create a 2-D stacked column within a 4 series stock char


S

Sam

I am trying to create an excel chart that combines the features of a 100% 2-D
stacked column (for comparison of 2 variables) and the 4 series stock chart.
I would desire to have my ideal chart being a 5-series stock chart with the
data variables arranged as 'Volume1-Volume2 (stacked up as in 2-D
column)-High-Low-Close'. This is slightly different from the current 5-series
stock chart available in the excel spreadsheet. Can anybody help please?
Thank you.
Sincerely,
Samuel
 
Ad

Advertisements

S

Sam

Thanks Bernard. I have looked through the sites you sent me. I am able to
create the clustered charts just as indicated. However, if you look at the 4
series stock charts, you have for example series 1 representing the gene A
frequency, series 2 representing the hemoglobin (Hb) 75th percentile, series
3 representing the Hb 25th percentile and series 4 representing the Hb
median. The first series is represented as columns charts, while series 2, 3,
and 4 are represented as bars (similar to error bars) with upper and lower
limits showing the Hb 75th and 25th percentiles respectively and the middle
value reresenting the Hb median. Note that the above example would apply for
gene A alone
Is it possible then to have for example gene A and gene B both presented as
stacked column chart and the series values inserted as examplified above?
Thanks.
 
B

Bernard Liengme

Send me a sample file
If possible make a pencil sketch of how you what the chart; scan it and
include it in you email
Please repeat the test of the message in your email also so I do not need to
hunt <grin>
Get my email address from my website
best wishes
 
S

Sam

Thanks again Proffesor. I have drafted the chart as i would want it. However,
i am not able to access your email address from your website since i do have
an active microsoft outlook profile. How do go around this problem?
Thanks.
Rergards.
Samuel.
 
B

Bernard Liengme

bliengme ampersand stfx dot ca

Any one can visit my site without Outlook
 
Ad

Advertisements

S

Sam

Thanks Proffesor. I have sent you the information you requested. I look
forward to hear from you.
Sincerely,
Samuel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top