Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combining a regular bar chart and stacked bar chart
Hi, I have 2 y-axis data series and years for the x-axis. For each year I
have side-by-side bars for the 2 different data series. For one specific year, I would like to have stacked bars. I want to combine data from the first half of the year and the second half of the year to create one bar for each data series, with the 2 portions of the data making up each bar as a different colors. Is this possible? Please help me ASAP as this is for a publication at work. Thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combining a regular bar chart and stacked bar chart
The first link on this page gives an example of the data arrangement you
need to achieve this visual effect: http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Marshall" wrote in message ... Hi, I have 2 y-axis data series and years for the x-axis. For each year I have side-by-side bars for the 2 different data series. For one specific year, I would like to have stacked bars. I want to combine data from the first half of the year and the second half of the year to create one bar for each data series, with the 2 portions of the data making up each bar as a different colors. Is this possible? Please help me ASAP as this is for a publication at work. Thanks. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combining a regular bar chart and stacked bar chart
Sorry, I didn't think it would make a difference, but I should have said I am
currently using a "Line - Column on 2 Axes" graph from the custom types. So I need the secondary axis for the 3rd data series. I have 3 data series and just need one year to have stacked columns for the each of the 2 columns at that year. Is this possible? "Jon Peltier" wrote: The first link on this page gives an example of the data arrangement you need to achieve this visual effect: http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Marshall" wrote in message ... Hi, I have 2 y-axis data series and years for the x-axis. For each year I have side-by-side bars for the 2 different data series. For one specific year, I would like to have stacked bars. I want to combine data from the first half of the year and the second half of the year to create one bar for each data series, with the 2 portions of the data making up each bar as a different colors. Is this possible? Please help me ASAP as this is for a publication at work. Thanks. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combining a regular bar chart and stacked bar chart
The columns are all of stacked column type on one axis, just some don't have
any columns stacked on top (i.e., the values are zero). The data is staggered to provide clustering and spaces between clusters. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Marshall" wrote in message ... Sorry, I didn't think it would make a difference, but I should have said I am currently using a "Line - Column on 2 Axes" graph from the custom types. So I need the secondary axis for the 3rd data series. I have 3 data series and just need one year to have stacked columns for the each of the 2 columns at that year. Is this possible? "Jon Peltier" wrote: The first link on this page gives an example of the data arrangement you need to achieve this visual effect: http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Marshall" wrote in message ... Hi, I have 2 y-axis data series and years for the x-axis. For each year I have side-by-side bars for the 2 different data series. For one specific year, I would like to have stacked bars. I want to combine data from the first half of the year and the second half of the year to create one bar for each data series, with the 2 portions of the data making up each bar as a different colors. Is this possible? Please help me ASAP as this is for a publication at work. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I combine a stacked bar with regular bars on the same chart? | Charts and Charting in Excel | |||
combining a stacked column and line chart together | Charts and Charting in Excel | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
Combining stack column chart and non stacked | Charts and Charting in Excel |