|
How can i create a 2-D stacked column within a 4 series stock char
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 |
How can i create a 2-D stacked column within a 4 series stock char
See
http://peltiertech.com/Excel/ChartsH...sterStack.html http://peltiertech.com/Utility/ClusterStackUtility.html http://people.stfx.ca/bliengme/ExcelTips/Columns.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sam" wrote in message ... 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 |
How can i create a 2-D stacked column within a 4 series stock
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. "Bernard Liengme" wrote: See http://peltiertech.com/Excel/ChartsH...sterStack.html http://peltiertech.com/Utility/ClusterStackUtility.html http://people.stfx.ca/bliengme/ExcelTips/Columns.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sam" wrote in message ... 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 |
How can i create a 2-D stacked column within a 4 series stock
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sam" wrote in message ... 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. "Bernard Liengme" wrote: See http://peltiertech.com/Excel/ChartsH...sterStack.html http://peltiertech.com/Utility/ClusterStackUtility.html http://people.stfx.ca/bliengme/ExcelTips/Columns.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sam" wrote in message ... 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 |
How can i create a 2-D stacked column within a 4 series stock
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. "Bernard Liengme" wrote: 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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sam" wrote in message ... 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. "Bernard Liengme" wrote: See http://peltiertech.com/Excel/ChartsH...sterStack.html http://peltiertech.com/Utility/ClusterStackUtility.html http://people.stfx.ca/bliengme/ExcelTips/Columns.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sam" wrote in message ... 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 |
How can i create a 2-D stacked column within a 4 series stock
bliengme ampersand stfx dot ca
Any one can visit my site without Outlook -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sam" wrote in message ... 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. "Bernard Liengme" wrote: 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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sam" wrote in message ... 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. "Bernard Liengme" wrote: See http://peltiertech.com/Excel/ChartsH...sterStack.html http://peltiertech.com/Utility/ClusterStackUtility.html http://people.stfx.ca/bliengme/ExcelTips/Columns.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sam" wrote in message ... 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 |
How can i create a 2-D stacked column within a 4 series stock
Thanks Proffesor. I have sent you the information you requested. I look
forward to hear from you. Sincerely, Samuel. "Bernard Liengme" wrote: bliengme ampersand stfx dot ca Any one can visit my site without Outlook -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sam" wrote in message ... 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. "Bernard Liengme" wrote: 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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sam" wrote in message ... 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. "Bernard Liengme" wrote: See http://peltiertech.com/Excel/ChartsH...sterStack.html http://peltiertech.com/Utility/ClusterStackUtility.html http://people.stfx.ca/bliengme/ExcelTips/Columns.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sam" wrote in message ... 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 |
| All times are GMT +1. The time now is 01:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com