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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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?