| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stacked Column Chart - Total that isn't the sum of series | Charts and Charting in Excel | |||
| Excel 2007 - mixed type (line, column, stacked column) in one char | Charts and Charting in Excel | |||
| stacked column with series in variable locations | Charts and Charting in Excel | |||
| Combine stacked column and line chart w/series lines | Charts and Charting in Excel | |||
| To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
Linear Mode
