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

  • Thread starter Thread starter Sam
  • Start date Start date
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
 
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.
 
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
 
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.
 
Thanks Proffesor. I have sent you the information you requested. I look
forward to hear from you.
Sincerely,
Samuel.
 
Back
Top