Thread: creating stacked charts with two comparative columns

How do you create a stacked chart with two comparative columns, each column
containing different data series. Example: column one would have various
categories of type of items sold in $, column 2 would have $ shipped, back
ordered.
The columns would be grouped by month. How should the data be displayed in
the spreadsheet? Is this doable in Excel?

How do you want the charts to display? That'll help.

"birchbark" <birchbark@discussions.microsoft.com> wrote in message
news:269CE2F8-06FB-4ACD-9C00-7A2ED72BA516@microsoft.com...
> How do you create a stacked chart with two comparative columns, each
> column
> containing different data series. Example: column one would have various
> categories of type of items sold in $, column 2 would have $ shipped, back
> ordered.
> The columns would be grouped by month. How should the data be displayed
> in
> the spreadsheet? Is this doable in Excel?

Two columns would be side by side. Column A would be in 3 or 4 colours,
Column B would be in 2 colours, no space between these 2 stacked columns.
They would indicate one month results, then there would be a space and the
next 2 stacked columns would appear for the next month and so on.

"Barb Reinhardt" wrote:

> How do you want the charts to display? That'll help.
>
> "birchbark" <birchbark@discussions.microsoft.com> wrote in message
> news:269CE2F8-06FB-4ACD-9C00-7A2ED72BA516@microsoft.com...
> > How do you create a stacked chart with two comparative columns, each
> > column
> > containing different data series. Example: column one would have various
> > categories of type of items sold in $, column 2 would have $ shipped, back
> > ordered.
> > The columns would be grouped by month. How should the data be displayed
> > in
> > the spreadsheet? Is this doable in Excel?
>
>
>

Links on this page should direct you to what you need:

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"birchbark" <birchbark@discussions.microsoft.com> wrote in message
news:F5A60259-DAC6-49B0-841A-302429BAEA12@microsoft.com...
> Two columns would be side by side. Column A would be in 3 or 4 colours,
> Column B would be in 2 colours, no space between these 2 stacked columns.
> They would indicate one month results, then there would be a space and the
> next 2 stacked columns would appear for the next month and so on.
>
> "Barb Reinhardt" wrote:
>
>> How do you want the charts to display? That'll help.
>>
>> "birchbark" <birchbark@discussions.microsoft.com> wrote in message
>> news:269CE2F8-06FB-4ACD-9C00-7A2ED72BA516@microsoft.com...
>> > How do you create a stacked chart with two comparative columns, each
>> > column
>> > containing different data series. Example: column one would have
>> > various
>> > categories of type of items sold in $, column 2 would have $ shipped,
>> > back
>> > ordered.
>> > The columns would be grouped by month. How should the data be
>> > displayed
>> > in
>> > the spreadsheet? Is this doable in Excel?
>>
>>
>>

Thanks - I had just come across this link in a previous post and was trying
it out when I got your post.

"Jon Peltier" wrote:

> Links on this page should direct you to what you need:
>
> http://peltiertech.com/Excel/ChartsH...sterStack.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> "birchbark" <birchbark@discussions.microsoft.com> wrote in message
> news:F5A60259-DAC6-49B0-841A-302429BAEA12@microsoft.com...
> > Two columns would be side by side. Column A would be in 3 or 4 colours,
> > Column B would be in 2 colours, no space between these 2 stacked columns.
> > They would indicate one month results, then there would be a space and the
> > next 2 stacked columns would appear for the next month and so on.
> >
> > "Barb Reinhardt" wrote:
> >
> >> How do you want the charts to display? That'll help.
> >>
> >> "birchbark" <birchbark@discussions.microsoft.com> wrote in message
> >> news:269CE2F8-06FB-4ACD-9C00-7A2ED72BA516@microsoft.com...
> >> > How do you create a stacked chart with two comparative columns, each
> >> > column
> >> > containing different data series. Example: column one would have
> >> > various
> >> > categories of type of items sold in $, column 2 would have $ shipped,
> >> > back
> >> > ordered.
> >> > The columns would be grouped by month. How should the data be
> >> > displayed
> >> > in
> >> > the spreadsheet? Is this doable in Excel?
> >>
> >>
> >>
>
>
>